No fields available in Select/Filter Tool, but Browse shows proper data with 8 columns

Hi everyone,

For the past few days I have been trying to figure out why neither Select tool nor any other that lets you select a column detects any of them. The data comes from a Python script that sends a dataframe to Alteryx.

As you can see in the screenshot, Select tool does get the data (8 fields and 797 records).

I have tried these many times already:

- reload the workflow, run it again and again after resetting Alteryx

- copy and paste to a new workflow

Filter says 'no results found' but again, I see all the data with 8 columns when clicking on input of Filter Tool.

Any ideas?

Workflow

Python

Macros

Accepted answers

danilang

Hi @DamianPiatkowski

Check to see if you have Disable Auto Configure checked in User Settings->Advanced. This stops the metadata from being refreshed when making changes to a workflow and might account for your issue. It should be unchecked as shown below

If this doesn't solve the problem and the macro always outputs the same fields, you can work around it by adding a Text Input tool with only the field names followed by a Select tool to set the field types. Add a union after your macro and connect the output of the Selecttool to the input of the union. The metadata from the Text Input box tool is saved with the workflow and it will always propagate downstream

Dan

All comments

mceleavey

Hi @DamianPiatkowski ,

when you click the "Select Column" in your filter tool do you see the fields? You need to select a field and apply the filter logic before you can run it.

DamianPiatkowski

Hi,

No, I don't see any options, it says "no results found". Same with every other tool that has that dropdown (e.g. Text to Columns).

DamianPiatkowski

Thanks Dan, the workaround works.

I guess why the issue still occurs even with that option unchecked will remain a mystery 🙂

CSchaeffer

This just started happening with the upgrade to 2025.1.1.31 last week. Disable Auto Configure is not checked. Having to Run before the workflow reads the fields in the Input Data tool. A real drag. Any ideas out there?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703