topic Re: Inline model variable substitution in Geoprocessing Questions

Inline model variable substitution

BillTrask — Wed, 28 Mar 2012 15:33:46 GMT

Is it possible to use the inline model variable substitution when the input is a list of variables? I would like to be able to select a number of input soil shapefiles, clip each according to the same clip features, then name each resulting clipped soil shapefile according to its original input name.

I've made a general input feature (to be clipped) called 'Soil', set it to parameter and a list of values. I've parsed the name of 'Soil' and set the output variable from here as 'SoilName'. Finally, I use inline variable substitution for my clipped output feature by calling it 'Clipped_%SoilName%'. When I run the model, I input 2 features to be clipped: the soils shapefiles of Herkimer County and Montgomery County (in that order). When it's finished running, I only get the clipped Montgomery County with the name 'Clipped_Herkimer'.

I know that there are other methods of inline variable subing, such as the %i% option, but in this case the name is essential because I will be using this later in the model to perform a table join with each County's massive soils table. Any thoughts?

Re: Inline model variable substitution

markdenil — Wed, 28 Mar 2012 17:11:45 GMT

I would suggest converting your model to a python script (export the model and clean up the code). Then you can loop through lists or dictionaries to your heart's content.

I find Model builder works best for fast prototyping; when the process works once through in the model I then export it and build in the looping and error checking and whatnot.

Re: Inline model variable substitution

EdithFergus — Thu, 29 Mar 2012 00:27:54 GMT

I would suggest converting your model to a python script (export the model and clean up the code). Then you can loop through lists or dictionaries to your heart's content.

Re: Inline model variable substitution

BillTrask — Thu, 29 Mar 2012 17:54:43 GMT

Right, but there should be a way to do it in the model builder. Otherwise the option of using inline variable substitution is quite limited. Any other suggestions?

Re: Inline model variable substitution

curtvprice — Thu, 29 Mar 2012 19:04:47 GMT

Is it possible to use the inline model variable substitution when the input is a list of variables?

I know that there are other methods of inline variable subing, such as the %i% option, but in this case the name is essential because I will be using this later in the model to perform a table join with each County's massive soils table. Any thoughts?

If you use the Iterate Multivalue tool (or any other iterator), the iterator generates variables on each loop, just for this purpose. If what you are getting isn't exactly what you need, you can use the Calculate Value tool on each loop to manipulate these values to create the output pathname you want. use the output of the Calculate Value tool in percents embedded in your output file name, for example "Soil_%shapename%.dbf". Be sure and use preconditions to make sure the variable gets calculated by Calculate Value before you run the tool that uses its name for an output.

Re: Inline model variable substitution

BillTrask — Fri, 30 Mar 2012 15:20:08 GMT

Thanks, that worked. The only pitfall is that I had to manually enter in the output address: 'G:\Test\%Value%Clip.shp' for each of the output variables, which is both odd and self-defeating. You would think that the inline substitution would be able to handle this. If I don't copy and paste this same address onto the next line of the 'batch' table, I merely get the last clipped shapefile with the first shapefile's name.

Re: Inline model variable substitution

HenrikSvenningsen — Sat, 31 Mar 2012 12:14:31 GMT

The only pitfall is that I had to manually enter in the output address: 'G:\Test\%Value%Clip.shp' for each of the output variables.....

Have you tried: %Workspace%\%Value%Clip.shp....and just befor that set your workspace to: G:\Test

Re: Inline model variable substitution

BillTrask — Tue, 10 Apr 2012 14:03:17 GMT

The only pitfall is that I had to manually enter in the output address: 'G:\Test\%Value%Clip.shp' for each of the output variables.....

Have you tried: %Workspace%\%Value%Clip.shp....and just befor that set your workspace to: G:\Test

Yes, I tried that with the same result.

Re: Inline model variable substitution

ShitijMehta — Mon, 16 Apr 2012 21:27:20 GMT

Dear wjtrask,

Couple of things to check and try:

Share your model or a snap shot of your model.

How are you running the model?

If you are running from tool dialog - Make sure that your outputs are not intermediate (especially the one on which your inline variable substitution depends) Right click your green ovals and uncheck the intermediate such that they are not deleted after the model runs. Experiment with this. You can always check it intermediate if you do not need them after you run the model and also after you make sure that downstream tools are not dependent on any of the outputs marked as intermediate

Try these at 10.0:
Do not use a list variable INSTEAD

Put all your shapefiles in one place and use the Iterate Feature Class Iterator. This iterator has two outputs 1) the feature class path which you can connect to the Clip tool downstream, 2) Name- which is the name of the feature class. Use this variable name in your output as %Name%.

or

If you are using Multivalue Iterator use the Parse Path tool and set the second parameter of that tool to Name. Use the output of Parse path as inline in your downstream tools. Set precondition from Parse path to the next tool Clip.

Re: Inline model variable substitution

CrystalCarreon — Thu, 16 Aug 2012 18:51:04 GMT

shitijmehta:
Thanks so much for sharing! I used the parse path tool for inline variable input/output while using the iterate multivalue tool and it worked brilliantly!

Thanks again,
Crystal

Re: Inline model variable substitution

PapantzinCid — Fri, 15 Feb 2013 03:28:00 GMT

Hello All, I know this is an old thread but I am facing a similar issue. I am using ArcGIS 10.1 and am trying to export clipped datasets to a new file geodatabase. I tried using both the iterator method, the list of values, and the batch parse path method. I want to keep the same file name but change the output location. When I specify the new output location I use %Name% so that the original names will transfer over to the new output file geodatabase. When I do so I get the following error for both methods:
Start Time: Thu Feb 14 21:16:23 2013
ERROR 000210: Cannot create output C:\Users\Desktop\SanDiegoData\Output.gdb\%Name%
ERROR 000354: The name contains invalid characters
ERROR 000354: The name contains invalid characters
ERROR 000354: The name contains invalid characters
The table was not found. [%Name%]
Failed to execute (Clip)
When I try the same process without changing the geodatabase output location and name (the output automatically add the _clip) it works fine. Any suggestions? Am I using the wrong Wildcard/In-line Variable? As mentioned by someone else. It is essential that I keep the names the same and I would prefer to use the list of values method so that I can bring files in from different locations.
Thank you in advance for any help you can offer.

Re: Inline model variable substitution

curtvprice — Tue, 19 Feb 2013 14:44:33 GMT

The table was not found. [%Name%]

I highly recommend you focus on using the iterator method; multi-values are a bear to work with.

I don't see where you are populating a Name variable. If the variable does not exist, it gets put into your tool arguments unmodified.

The normal way to get that value is to use the Parse Path tool as described above in this thread.

Re: Inline model variable substitution

PapantzinCid — Wed, 27 Feb 2013 03:41:19 GMT

Thank you. After speaking to several other people they also suggested using the parse tool. Thanks so much for the reply!