Select Layer by Attribute Issues in Pro 3.1

[Ed_]

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:

[SLouq]

Have you tried 'Or'? instead of AND

[Ed_ · Accepted solution]

The same  query works fine outside the model builder on the same dataset.

[SLouq]

Try Street Address is '' instead of Street Address is equal ''

[Ed_ · Accepted solution]

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?

[DanPatterson · Accepted solution]

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

[Ed_ · Accepted solution]

Hi @DanPatterson, thank you for the quick response but, the `Table Select` tool is not working either. 

[Ed_]

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.