topic Re: Select Layer by Attribute Issues in Pro 3.1 in ArcGIS Pro Questions

Select Layer by Attribute Issues in Pro 3.1

Ed_ — Fri, 16 Feb 2024 14:58:38 GMT

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:

Re: Select Layer by Attribute Issues in Pro 3.1

SLouq — Fri, 16 Feb 2024 15:02:47 GMT

Have you tried 'Or'? instead of AND

Re: Select Layer by Attribute Issues in Pro 3.1

Ed_ — Fri, 16 Feb 2024 15:03:43 GMT

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

Re: Select Layer by Attribute Issues in Pro 3.1

SLouq — Fri, 16 Feb 2024 15:13:35 GMT

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

Re: Select Layer by Attribute Issues in Pro 3.1

DanPatterson — Fri, 16 Feb 2024 15:15:02 GMT

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

Re: Select Layer by Attribute Issues in Pro 3.1

Ed_ — Fri, 16 Feb 2024 15:23:00 GMT

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

Re: Select Layer by Attribute Issues in Pro 3.1

Ed_ — Fri, 16 Feb 2024 15:25:12 GMT

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?

Re: Select Layer by Attribute Issues in Pro 3.1

Ed_ — Fri, 16 Feb 2024 16:49:04 GMT

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.