Latest Contributions by ShitijMehta

Can you post an image showing the tools in the model that are upstream of the Eliminate tool? Also try this: Use Make Feature Layer tool to create a feature layer. Don't use any expression in this. Then use the Select Layer By Attribute tool to make a selection in the layer and connect the output of Select Layer By Attribute to the Eliminate tool. This should work. The Eliminate tool works on a selected features from a feature class. Make feature layer with an expression creates an output layer with only the features that honor the expression, whereas the Select Layer By Attribute tool  creates a output layer with all the features in it but with features selected based on the query. ... View more

Have you tried saving a copy of the feature class with the Copy tool? ... View more

Try: In the expression variable "Tags" LIKE '%String%' This is enough as at the run time the %string% will be replace by the value of the string i.e. music This is what you are doing: You are creating a variable for a wild card that you want to use. This variable is of data type string. The name of the variable is String (rename it to something else- xyz and use- "Tags" LIKE '%xyx%') You are substituting the variable name %String%/%xyz% in the expression ... View more

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