topic Re: ?Table Select does not work in Model Builder in Geoprocessing Questions

?Table Select does not work in Model Builder

gilweil — Thu, 17 Dec 2015 11:34:12 GMT

Hallo,

I'm trying to create a model that uses values from a single table, in order to perform a different calculation for each raster in a file.

Each raster is represented in the table by a row that contains the raster unique name (string), and 2 other fields with the numeric values for the calculation (slope & intercept).

I use "Iterate rasters" to go through the files, and "Table Select" where I select the relevant row for the parameters, by using %Name% (from the iterator) = name (the raster name in the table).

Doesn't work... the model gets stuck in the "Table Select" stage.

Does anyone have any idea why?

I attached python code and image of the model.

Thank you!

Re: ?Table Select does not work in Model Builder

LukeSturtevant — Thu, 17 Dec 2015 12:20:26 GMT

It would probably be best if you upload the actual model builder tool and not a python export of the tool. Thanks.

Re: ?Table Select does not work in Model Builder

gilweil — Thu, 17 Dec 2015 12:26:11 GMT

Okay, I added

Thank you

Re: ?Table Select does not work in Model Builder

LukeSturtevant — Thu, 17 Dec 2015 12:50:58 GMT

Is your table that you are selecting from in a local geodatabase or file system?

Have you tried putting single quotes around the %Name% in the selection expression?

Re: ?Table Select does not work in Model Builder

gilweil — Thu, 17 Dec 2015 12:56:28 GMT

yes,

doesn't seem to help.

The model also added in tbx

Re: ?Table Select does not work in Model Builder

gilweil — Thu, 17 Dec 2015 13:00:43 GMT

the table is from a local geodatabase

Re: ?Table Select does not work in Model Builder

LukeSturtevant — Thu, 17 Dec 2015 13:03:09 GMT

Then maybe try taking the double quotes off the field name:

name = '%Name%'

Re: ?Table Select does not work in Model Builder

gilweil — Thu, 17 Dec 2015 13:07:54 GMT

Did not work, sorry ...

Re: ?Table Select does not work in Model Builder

LukeSturtevant — Thu, 17 Dec 2015 13:09:31 GMT

Could you post a sample of your data? Maybe a raster and the table you are working with? Also could you post a screen shot of the error your are getting?

Re: ?Table Select does not work in Model Builder

gilweil — Thu, 17 Dec 2015 13:39:38 GMT

Sure, attached.

If I run the model in edit mode, when the model is open, it reaches the tool "Table select" and simply stops ("finished").

In the results panel I get:

<Cannot create output <value: 000210

Re: ?Table Select does not work in Model Builder

LukeSturtevant — Thu, 17 Dec 2015 17:13:06 GMT

Okay try this:

Add a Calculate Value tool in to calculate a valid name for the output table the code would be

"%Name%".split(".")[0]

Then change the output table name to t_%TableName%

Re: ?Table Select does not work in Model Builder

gilweil — Thu, 17 Dec 2015 18:14:25 GMT

Thanks a lot

I'll try it on Sunday

Re: ?Table Select does not work in Model Builder

gilweil — Sun, 20 Dec 2015 05:47:55 GMT

Perfect thanks!

Re: ?Table Select does not work in Model Builder

gilweil — Sun, 20 Dec 2015 06:39:59 GMT

Now I recognize another problem...

The model (Table select) selects only the first row in the table, the following outputs are empty tables

Re: ?Table Select does not work in Model Builder

LukeSturtevant — Mon, 21 Dec 2015 12:00:39 GMT

I'm not sure why it would only be running for one table entry for you. I've attached an edited toolbox. This seems to work with the example data you provided just fine on my end.

Re: ?Table Select does not work in Model Builder

gilweil — Mon, 21 Dec 2015 12:54:00 GMT

Thank you again,

Your solution works great, but I I came across other two problems I have not seen before:

1. The select tool is case sensitive

2. The model does not overwrite properly the previous outputs

After I treated these specific problems, everything works properly.