Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

Dynamically Select Fields based on results of DropDown Selection


Hi, struggling with a challenge.


I have a table with 16 fields.




Fund1, Fund2, Fund3, Fund4, etc.


I have a drop down with 






I'd like my dropdown selection to dynamically select the relevant columns. Does anyone have a solution to this?


Help much appreciated. 


I think you'd want to use a list box rather than a drop down.


The list box will allow you to have a check box per column, rather than the single option the drop down allows.


If you set the list box to accept the field list from your input tool/stream this will load those fields.


Like the attached (if you rename to .yxwz).


Thanks. The List Box to MultiSelect does work. I guess I can comment "Please only select one'. 


Was thinking as it's a one - to - one relationship - So when I pick fund 1, i only need the fund 1 column back. 




Ah sorry, I misunderstood.


You can connect the drop down in the same way as the list box if you want the user to only select one.


I would never rely on the user to only select one

You can do this by feeding the Question output into a Dynamic Select and then using a formula to choose which columns to keep.



Quick sample based on @JoeS attached


One slight warning - remember to tick:


as the field output changes...


Think i worked it out - [Name]=[#1]





@jdunkerley79 @JoeS 

New issue, is that as the fields are being dynamically selected in the dropdown of the app. A lot of my downstream tools aren't functioning now, especially summarise tools. 


What is the best way to cope with this changing upstream field situation?


I can share a sample workflow or screenshots if that would help more?


Hi @CiaranA 


Yeah, it'd be best to share your workflow.


I'd guess that you may need to change the shape of your data using the transpose tool before a summarize and then a cross tab after.


But definitely best if you can upload your example


Would this be better as a chained app?


I've attached a sample which aims to show that by dynamically picking a fund, your downstream tools then reference that fund's particular data, pivot it up and summarise in a table.