Input to Drop Down Interface from Other tools

[nabandla]

Hi All,

I am creating analytical app to input the values from another tool

Drop Down Config:

Action Interface Config :

My filter Tool Config 

When I am running Analytical App in the drop down i am getting the Column names instead of Column Values

Ideal Output should show the category Values in Drop Down

attached the analytical App

Thanks in Advance 

Regards,

Naveen Bandla

[MichalM]

@nabandla 

Unfortunately the way the drop down is populated will only work for metadata (column names), rather than the actual values within the column. The reason for this is that the underlying file/data can change, and Alteryx needs to run to read the data in and obtain the list of unique values. 

• If your values are static, you can build out a lookup file and use this instead - point the Drop down to the file. 
• If your values are dynamic, you will need to build a two step process we call a chained app. Step 1 will simply run a Group by on your values column and generate that lookup file. A successful run will trigger the step 2, which will use the lookup file to populate the drop down.

You can find out more about chained apps here and here.

[patrick_digan · Accepted solution]

@nabandla I've put an idea out there that would solve your problem if implemented. You should star it/add a comment if you want!