Table Select Not Working

[JohnMcConalogue]

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.

[DanPatterson_Retired]

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?

[JohnMcConalogue]

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?

[DanPatterson_Retired]

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

[JohnMcConalogue]

doing in model builder but I havent  a clue about In_memory

[DanPatterson_Retired · Accepted solution]

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

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

[JohnMcConalogue]

Thanks Dan