Dynamic selecting columns

[Ekmi9]

I have one data set like :

(Column Name are:- )

I have one mapping sheet which contain the column name which I want to select :

i have tried dynamic select tool but on dynamic select tool we just allow to to give string values on from mapping file how i can dynamically select the column names from mapping file ?

my alteryx ver is 2020.2

Appreciate your help

Thanks in Advance!

[IraWatt · Accepted solution]

Hey @Ekmi9,

Think this is what you want to do:

Use a cross tab and union to output just the common subset of columns you want.

Any questions or issues please ask :)
HTH!
Ira

[binuacs]

@Ekmi9 If @IraWatt not working Can you provide a sample input files with expected output file?