Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

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

6 - Meteoroid



I am trying to make an drop down menu interface. 



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. 

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:

Alteryx Alumni (Retired)

Hi @bmittal11 ,

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