topic Re: Table Select Not Working in ModelBuilder Questions

Table Select Not Working

JohnMcConalogue — Mon, 16 Apr 2018 13:41:58 GMT

I have created a Feature layer and I want to do a SQL select on the feature layer. To accomplish this I have converted the feature layer to a table using the Create Table tool. Now I am attempting to carry out a SQL select on that table using the Table Select tool.

The problem is that when I go to build the SQL expression, the fields contain no values and are blank, yet in the feature layer the fields contain values.

Re: Table Select Not Working

DanPatterson_Retired — Mon, 16 Apr 2018 14:13:59 GMT

According to Table Select it supports

The input can be an INFO, dBASE, or geodatabase table, a feature class, table view, or VPF dataset.

Do you mean a feature layer ? or feature class?

Re: Table Select Not Working

JohnMcConalogue — Mon, 16 Apr 2018 14:17:02 GMT

It is a Feature Layer.

I am trying to select certain records from the feature layer, is there another way to do this without converting to a table?

Re: Table Select Not Working

DanPatterson_Retired — Mon, 16 Apr 2018 14:21:47 GMT

Why not do it in_memory if you don't want to create a physical table on disk... you can dump it when you are done with it if you are doing this in a script or modelbuilder

Re: Table Select Not Working

JohnMcConalogue — Mon, 16 Apr 2018 14:24:03 GMT

doing in model builder but I havent a clue about In_memory

Re: Table Select Not Working

DanPatterson_Retired — Mon, 16 Apr 2018 15:25:26 GMT

John... http://pro.arcgis.com/en/pro-app/help/analysis/geoprocessing/modelbuilder/the-in-memory-workspace.htm

It is like it exists... briefly, but use Delete when done to be safe

Re: Table Select Not Working

JohnMcConalogue — Mon, 16 Apr 2018 15:33:02 GMT

Thanks Dan