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

[bmittal11]

Hey, 

I am trying to make an drop down menu interface. 

INPUT :

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. 

[DataNath · Accepted solution]

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]

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...