So I have this Excel XLSX file that I am bringing in as a GDB table into a model builder. I added a `Delete Field` tool to delete two columns (which works fine) and then I connect the output of that to the `Select Layer by Attribute` tool. But, the `Select Layer by Attribute` tool query doesn't work, like it does not return any selection, even thought the query works fine outside the model.
X IS NOT NULL And Street_Address = ''
Whole model:
Solved! Go to Solution.
The same query works fine outside the model builder on the same dataset.
If it is just a table, did you try
Table Select (Analysis)—ArcGIS Pro | Documentation
or you might want to add the modelbuilder tool to your workflow
If Selection Exists (ModelBuilder)—ArcGIS Pro | Documentation
Hi @DanPatterson, thank you for the quick response but, the `Table Select` tool is not working either.
Hi @SLouq, thank you for the quick response but, I can't seem to find `is` under the conditions drop down menu. Are you saying I should type `is` instead of `=` in SQL mode?
Have you tried 'Or'? instead of AND
The same query works fine outside the model builder on the same dataset.
Try Street Address is '' instead of Street Address is equal ''
Hi @SLouq, thank you for the quick response but, I can't seem to find `is` under the conditions drop down menu. Are you saying I should type `is` instead of `=` in SQL mode?
If it is just a table, did you try
Table Select (Analysis)—ArcGIS Pro | Documentation
or you might want to add the modelbuilder tool to your workflow
If Selection Exists (ModelBuilder)—ArcGIS Pro | Documentation
Hi @DanPatterson, thank you for the quick response but, the `Table Select` tool is not working either.
I ended up using the `Export Table` tool to run the query (which now works) as well as delete the columns I don't need in one go.