topic Re: Inline variable substitution in ModelBuilder with submodel in ModelBuilder Questions

Inline variable substitution in ModelBuilder with submodel

RebeccaFuda — Wed, 06 Feb 2019 17:19:52 GMT

I have a model that uses two iterators, and so I am using submodels. However, I am having trouble getting my main model to recognize inline variable substitution for a variable from the submodel. When running the intersect tool after running the submodel, I get the following error:

Executing (Intersect): Intersect "E:\BFuda\GIS_Data\Properties_For_Sale\overlap_layers\sg_cor.shp #;E:\BFuda\GIS_Data\Properties_For_Sale\parcels_final\analind.shp #" E:\BFuda\GIS_Data\Default.gdb\%Name_wl% ONLY_FID # INPUT
Start Time: Wed Feb 06 10:12:37 2019
ERROR 000210: Cannot create output E:\BFuda\GIS_Data\Default.gdb\%Name_wl%
The table was not found. [%Name_wl%]
Failed to execute (Intersect).
Failed at Wed Feb 06 10:12:38 2019 (Elapsed Time: 1.35 seconds)

The model and submodel are shown below:

The inputs for the Intersect tool are shown as follows:

Re: Inline variable substitution in ModelBuilder with submodel

RebeccaFuda — Wed, 06 Feb 2019 17:56:55 GMT

I solved this problem by designating the Name_wl variable as a parameter within the submodel. Then within the main model, I right-clicked on the submodel and chose Make Variable | From Parameter | Names_wl.

Re: Inline variable substitution in ModelBuilder with submodel

AbiDhakal — Fri, 02 Aug 2024 17:47:29 GMT

I'm using a ModelBuilder to select Multiple values from a layer and it is not working. It only works when I select a single value. What am I doing wrong please.

Model:

Select Layer By Attribute expression window:

Parameter:

Geoprocessing:
In the window below marked in red, if I only put one value (SPB) then it will select, however if I put multiple values (SPB, EAB, etc.) as shown below it will not select.

I've added a variable to the model that would allow me to put Multiple values.

Please help me.

Thank you,
Abi