Latest Contributions by ShitijMehta

If you are using 10.0 try the Iterators in ModelBuilder. ... View more

Hello Chris, Can you give some details such as: Are you using 10.0 sp2? Which field are you joining on? You are joining what to what? After joining what do you see. From my investigation: With Add Join tool: From your data I tried to join the table to a feature class using the idvoie field. The Null that you see are because of the the existing Null values in the feature classes idvoie field before join. Using the classant field results in just one field with Null as there is no field value "Commune de La Garenne Colombes" in the ref_voie table. With Join Field tool: I joined the table to the feature class based on the classant field and one or the records values (Sadi Carnot (rue)) which exists in both the feature class and table and yet had Null Value after Join. The reason for that is this value - Sadi Carnot (rue) has a space at the end in the feature class and no space in the ref_voie table. How to find - Start the edit session and go to that field value. Put your cursor at the start of the field value and then use the arrow to go right till the end. You will notice that at the end of the field value i.e .......) there is a trailing space like this - Sadi Carnot (rue) (<SPACE) Do the same with the table field value. You will notice there is no space - - Sadi Carnot (rue)(<NOSPACE) Trailing space differences will cause the output to have NULL values after Join. ... View more

From within ModelBuilder: You have to use the Remove Join tool to remove the join. If you save the model after running once it will save the state of all the tools and the intermediate data unless you go click model menu> delete intermediate data. or Rerun the model uptill the tool before the Add Join tool and hit validate. Now rerun the whole model. ... View more

Check Value List filter Also check the blog - Generating choice list from a field For your purpose simply setting a value list on a string type variable will help. ... View more

I am sure you have made sure but just in case.. Hope you are applying the point symbology .lyr file to the point feature classes and polygon .lyr to polygon feature classes and kine  .lyr to line feature classes. ... View more

How are you exporting the selection to a shapefile? Copy Features tool? Are you setting the symbology by right ricking the output (green oval) and from Properties> Layer Symbology tab? Are you using 10? Service Pack? ... View more

Feature Class To Geodatabase tool output in ModelBuilder does not have the option to import the Layer Symbology as the output of the tool is a workspace or a feature dataset. The option to import the symbology that you see is under the data type tab to be used with the feature set data type. If you want to add the layer symbology, you can create another model with just the Iterate Feature Class Iterator and define the layer symbology to the output of the iterator.  For the input to the iterator use the geodatabase that you used to output your shapefiles. ... View more

I am glad you found a workaround. This is what we found from our testing: "%string%" - Works "%string%%" - Works "%%string%%" - Unfortunately fails. We will work on fixing it. Meanwhile there is another workaround. See attached image and the toolbox (version 10). ... View more

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