Alteryx designer Discussions

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

Select Fields from Large Dataset based on source file

Highlighted
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? 


Regards,


Adam

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@aehrenwo,

 

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.

 

 Capture.PNG

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

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