Latest Contributions by ShitijMehta

Hi, Please can you share your model with some sample data. You are using 10.0? sp? or 10.1? Thanks! ... View more

Are you using 10? sp? This is a know issue and has been addressed in 10.1 sp1. ... View more

Please can you share the model and the data/sample of the data? Are you using 10? sp? ... View more

Hi Andreas123. Check the image attached. Try something like that. Read Lists ... View more

Thanks for improving it Curt!!! I bet it will help a lot of people looking for a way to write a custom error, warning or message. Point under consideration - about the need for a tool in ModelBuilder to do that. ... View more

Ok - Row Why a new row.? What do you want to put in your new row? How many field (columns) exist in your excel? Meanwhile try this: If you want to use it in your model use the Table To Table tool to first convert the excel to a table in a file geodatabase. This will ensure all the other tools work well with your table in a file geodatabase. Once you have a table make a copy of it. Delete all but one record (or as many as you want). Delete the contents of the row if you want empty row. We make a copy of this so that schema (fields) are same as the incoming table. Then use the Merge tool to merge the original and the copied empty table. Note - The schema of the incoming tables should be consistent every time to Merge the incoming and this copied table. Use Iterate Tables iterator to iterate over more then one table. ... View more

Is this table an excel sheet? ... View more

There is a series of blogs on if-then-else blogs for 10 that will help you. If you are stuck at "if" �?? Part 1 If you are stuck at "if" �?? Part 2 �?? Example of using Script tool to create branches using if-else logic If you are stuck at "if" �?? Part 3 �?? Does Extension Exists model example If you are stuck at "if" �?? Part 4 �?? Does Selection Exists model example If you are stuck at "if" �?? Part 5 �?? Does Projection Exist model example ... View more

Hi crazymatt, I see your attachments. Try this: Validate the entire model and save. Now try running. Do the tools run? What field are you grouping your Iteration on? What is the value in group by ID? If empty it defaults to OID or FID. Open your Get Field Value tool? Which field are you getting the value for. (Get field value only gets the first value of the field in a table). I assume it is the file path field, is it? What is the data type you are setting? I am assuming Feature Class. Right click the Get Field Value tool and click Run. Does this tool run? double click on the output and check the value? Is the value correct? Now right click the Clip tool and Run. Does the tool run? Let me know if this helps. If not, share your model and sample of your data. ... View more

Hi crazymatt, You wrote: I can't figure out a way to have it return the field with the filepath and use that as the input for the clip process. Is this a field in the shapefile with features you want to use to clip? This field value is a path to ___________? what? If you are selecting a feature using feature selection iterator and want to get a field value try using the Get Field Value tool. This is a Model Only tool. You can find it from Model>Insert>Model Only>Get Field Value. This will return the field value. Then you can use the output variable of the Get Field Value tool as inline variable in the next tool (the tool you want to use the path (field value in) Can you share a snapshot of your data, table and field that you want to get the value from? Also, How do you want to use this field value? ... View more

Can use Make Feature Layer or Make Table View ... View more

Hi MCline19, Try this: Put quotes around the x("%CompareStatus%") in the expression of the Calculate Value tool. Does that work? ... View more

Hi MCline19, Check the attached image. Hope this helps. Write back if this does not work. ... View more

Are you iterating this model? Please can you share a snapshot? Can you try using the Append tool to merge all the tables into a target dataset (yes, u will have to create a target dataset with the schema of all possible fields that your tables could contain). Read tool help. ... View more

I am glad it worked for you. Enjoy building models! ... View more