Latest Contributions by ShitijMehta

Try the tool Get Field Value after selection and use the output of the tool as inline variable substitution in the output path name. ... View more

Read the Advanced use of Model Iterators section from the link. ... View more

arcpy.env.worspace should be a workspace like a folder or a geodatabase and not a path to a specific shapefile. May be this is the issue. or when you pass a path in the expression you should do it like this: r"%Workspace%". or This error code covers a number of Python errors: Example error 1: exceptions.TypeError: cannot concatenate 'str' and 'int' objects. The above is a Python-specific error. The calculation is attempting to add or concatenate a string and a number. Example error 2: Invalid field shape@distance The above is an error using the geometry object. The distance method is not a valid method of the geometry object. ... View more

ok. Lets try again. So you have some string values provided by the user say : Babbler, Sparrow and Crow. You want to check if any or all? Babbler, Sparrow and Crow values exists in a field called birds in your input feature class. Is this correct? How do users provide these values. A separate variable for each user input, meaning a variable for Babbler, another separate variable for Sparrow and so on? or the user provides these values in a single multivalue variable? You want to check if a particular value exists in a field???? ... View more

Hi You want to check if a particular field exists in a feature class or not: if this is correct: check the attached example of how to use the Calculate Value tool and the python code. Hope this helps. Let me know. ... View more

Hi Shiko, Try this: Create a model: - Use a selection tool like make feature layer/ Select a layer By attribute/Select to select the records and then pass the output selection to the Summary Statistic Tool : Summing the field  you want to for the selected records > then use the Get Field Value tool (Only works in ModelBuilder) to get the sum value from the statistic table. You can then use this sum value in the tool you want. You can make the output of the summary statistic tool in_memory so that you don't have to save an extra dbf table. Hope this helps. ... View more

Hi, Can you let the last output of the iteration that you want to delete and use in feedback be overwritten for each iteration rather than creating a new one per iteration? This way you don't need to delete all the outputs except the last. You can do this be leaving the last output name that is not unique for each iteration: c:\Temp\abc : This way the same abc gets created for every iteration. ... View more

Hi, Check the example 3 from this blog "If you are stuck at if - Part 1" to get some idea. ... View more

Hi, Read the Advanced use of model iterators section. It has to do with making the variable a model parameter and saving the model before dragging and dropping into the main model. ... View more

Hi mike.robb, Check the attachments. This model example might work for you. For this model you need to know the following: Integrating a model within a model Lists Precondition Parse path With Lists variable you can select all your CAD files from the catalog window and drag and drop them on the List type CAD dataset variable. You don't need to browse for each one separately. You can create this variable by insert> create variable> CAD dataset. Then make it a list type from its properties using the information in this link. Hope this helps. If this seems much .. Python make be a way for you. I tried this model and it worked for me. I have attached the toolbox containing three models just for reference. No data is included so the models might show the broken links. ... View more

Hi, From the screenshot this is what I understand: You have say two values in your variable called type: Value 1 and Value 2 which the user provides as it is a model parameter. This is how the iterator works: It takes the first value: value 1 and sends that value to the Select tool. This tool creates a new output based on your selection and sends it to the Collect Values. The iterator now runs for the second time for Value 2 and creates a new output. This is where I am guessing is the problem. Your output file  in the Select tool does not have a unique name for each iteration so it overwrites the  same file over and over again. If you need a unique name for each iteration you have to use in-line variable substitution %Type% something like this: C:\Temp\%Type%. This will ensure all the new outputs have a unique value. After this you want to merge - Please check Advanced use of model iterators You can also use %n% in the output name  like this: C:\Temp\Output_%n%. This will create new outputs with names like this: Output_0, Output_1 and so on If you choose to use %Type% and the type values have spaces or any special characters in them you will need to use the Calculate Value Tool to remove the spaces before using the value as inline variable. Check Calculate value help. ... View more

Use selection tools like Select, Select Layer by attribute, Table Select, Make Feature Layer. Build a query if field1= 3 or field1=4 or field1=5 or field1= 3 and field1=4 and field1=5 Am I missing something in your question? Let me know with a screenshot of your table if that is the case. ... View more

May be this will help: For details on the expression syntax see Building an SQL Expression or SQL Reference. ... View more

Intermediate data will only apply to tools that create new output datasets. If your tools are like Add Field which only modifies the input then there is no intermediate data. Such outputs are called in-out derived data (modify input. NO new output) See if this information might help solve part of the mystery. ... View more