We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Update the next drop down menu after selecting a specific value in the previous drop down.

bmittal11
6 - Meteoroid

Hey, 

 

I am trying to make an drop down menu interface. 

INPUT :

bmittal11_0-1661284938535.png

The first column is consistent. I am attaching my current workflow below. What I am doing is that, first I select the "ecuAcronym" from the drop down. If I select "ABS" it should only filter all the values that are related to "ABS" in the above input.  Then I select "DID" in the next drop down and the drop down should only display "DID" vales for "ABS" only in the drop down and then it filters "VIL timestamp"and "Decoded value " in the next drop down.

 

The problem:

It's with the highlighted text above, as I said the drop down should display only filtered data for "ecuAcronym" selected. but currently the dropdown menu displays all the data in the input sheet  for that specific column. I want the drop downs to display data that is filtered according the selection made in the previous drop down and not everything that is on the input sheet. 

 

I am attaching the workflow, you can run it as an app and see what I mean. 

I am also attaching the Input file.

Please let me know If you have any questions. I hope I was able to make sense. 

2 REPLIES 2
DataNath
17 - Castor

Hey @bmittal11, you’ll need to create a chained application to do this so that only relevant values are carried through to the next dropdown:

 

https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120#ams-14

 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Chained-Alteryx-Analytic-Applicatio...

oly
Alteryx Alumni (Retired)

Hi @bmittal11 ,

Chained apps or an alternative solution through SQL query with a filter parameter that was shared here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Macro-Dynamic-Drop-Down/m-p/358491#M65... 

Labels