Alteryx designer Discussions

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

Select Fields from Large Dataset based on source file

8 - Asteroid

I figured this would be an easy question., but can't find something identical here... 


Is there any easy way to define the Select tool choices based on a list from another data input. I have a list of fields I know I want to include in the final output,  but it could change based on testing I am doing (there are over 100 fields) and I would  prefer to only have to update the one excel file and then execute the workflow again. 


Any suggestions? 



Alteryx Certified Partner
Alteryx Certified Partner



One way that you can do this is to transpose your data, use a join to filter against a set of desired elements, then put your data back to it's original form.






Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.