community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Dynamically select columns based on configuration File

Hi,

 

I have two Excel Files (Let's call them X and Y). X has 40 columns with 5 rows. (Name of columns are well defined). Y is a 10* 1 table which contains the target column names. I want to output only those columns in X whose names are present in Y. Thank you for your help! 

Alteryx Certified Partner

Hello Anand1994,

 

You can use a union field to unite both files and select in union tool to only 'output common subset of fields' as image attached.

 union field.JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Hope it helps.

Fernando Vizcaino

 

Quasar

You could Transpose the fields from your input, then Join to the lookup table and finally Crosstab the joined records.

 

 

Labels