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.
Solved! Go to Solution.
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