Latest Contributions by ShitijMehta

Can you add a snapshot of your model and the select query dialog? How/Why/Where are you using the wild card substitution? These wont work: "Tags" LIKE '%%string%%' "Tags" LIKE '%'%string%'%' """Tags" LIKE '%"""%string%"""%'""" ... View more

Do you have any 10 service pack installed? ... View more

Eric, Please post a snapshot. Also, try using Iterate Feature Selection or Iterate Row Selection iterator. You can group based on many fields to make a selection. Then can you a Calculate Field to calculate what ever you want on that selection. ... View more

May be nested model or just an if-then-else logic: See If-Then-Else Part 1 If-Then-Else Part 2 ... View more

Try: Creating two separate models. (Is this a possible option?) or I am not sure what your branch two is doing, but Create nested models/sub models/model within a model. Tutorial - One of the tutorial will show you how to create a nested model. Again not knowing what your branch 2 is doing you can use the Collect Values tool to collect all the outputs from all the iterations and pass them to the main model. Suppose your main model is using the merge tool, it is easy use the output of the collect values from your 1st iterating model directly as input to merge. Merge tool takes a multivalue input so all values from the Collect Value can go into merge without problem. or Read the document on nested model and try something like the attached image. Hope it helps. ... View more

Try: There is something called Precondition. You can set a precondition from the last tool of your branch 1 to the first tool of your second branch. Check the link. If this is not useful: Please give some more details. Which branch/What is that branch doing? ... View more

Select LAYER by Attribute = Feature Layer as input ... View more

Check attached image: Is this what you are doing? Pls provide some more details. You are working with 10 service pack 2? ... View more

If you want to run the tool on feature classes and stand alone tables try to use the data type - Table View. ... View more

Hello bokeefe, I see your problem. I don't have a ready solution for you, but I do have some suggestions for your consideration. This is what I would do: Get a bit more familiar with ModelBuilder. [INDENT][INDENT][INDENT] How to run tools in ModelBuilder How to make model tools.[/INDENT][/INDENT][/INDENT] 1. Create a model. 2. Use Table to Table tool to convert the excel sheet to dbf table in ArcMap. 3. Expose the Input parameter of the Table To Table tool and make it a model parameter (This would allow you to enter the sheet from the model tool dialog). Read help. 4. I would create a polygon feature class - using the Create Fishnet tool before hand and give each polygon a unique ID - 1,2,3.... using Add Field, Calculate Field. 5. I would give the records in my table (same table i brought from excel) same unique ID 1,2,3 (I am assuming that when we join the table to a polygon, the location of the polygon doesn't matter till this point. So, any record with unique id 1 of table getting joined to polygon with id 1 wouldn't matter with respect to its location). This part is necessary to avoid repetitive clicks from your end to create a polygon and then running the model. 6. Then just use Join Field tool and join them based on the Unique ID field that you created. Is it necessary for you to click at a particular location to create the polygon? (There is a data type called Feature Set that will let you draw the polygon interactively. You can then use Copy Features tool to copy that polygon to a new dataset and then join.) Hope this helps. ... View more

Are you using %n% inline variable in the output name to save each output of the iteration? Help at 9.3 on inline variable substitution Other resources: If you are using 10.0 - you can use iterators: Help - Iterators     Tutorials If you are using 9.3.1 you need to use a series type variable in the model to iterate. Help - Series     Also check Lists for batch processing     Model example using Series - Example 1     Also check the Iterate Field Value script tool - may be this will help with some other process. ... View more

Hello firani41, Hello thiago_nascimentodf, Can you share your model with a subset of your data? It will help see the problem and suggest an appropriate solution. Thanks! ... View more

Just a clue: Lets tackle this two part problem one at a time : You entering address and the model splitting the address into 1/2/3/4 parts and adding them to a field The model remembering a part of the old address and asking you if you want to add another on the same street. Try this: Create a model Create a string variable. Rename this "Address". Make it a Model Parameter. This one will let you enter the address from the model tool dialog and you wont have to open the model each time. Now add Calculate value tool. Rename the output of the Calculate Value tool to "HouseNumber" Pass "Address" as inline variable substitution in the expression ("%Address%") (Click on link and read help and check the attached image) Now use Python method (.split) to split the string and get each item of the list. (check attached image). Now Add Field and Calculate Field. In Calculate Field use the output of the Calculate field tool as inline variable (%HouseNumber%) in the Expression parameter. Add a precondition from the output of Calculate Value tool to the Add Field tool. Repeat adding and calculating for other parts of the string address by changing the value returned [0]/[1]/[2] Use this process in in tools based on your workflow. ... View more

Try Feature Set ... View more

Check If-then-else part 1 and If-then-else part 2 Any ModelBuilder questions belong in the Geoprocessing forum. ... View more