Hlookup - copying columns from one datatset to another basis Hlookup

[Anwita]

I have an excel template that contains 98 columns arranged in a particular order. I have a 2nd datatset that is a subset of 1st datatset , that is it has some of the columns but they are not in the order like in 1st table. In the manual process i would copy headers from first table, do a hlookup with 2nd datasets to see which columns are present and then copy those relevant columns into 1st table under respective columns. I'm new to Alteryx and totally lost as to how to replicate this manual step in Alteryx. Please help !

[DavidSkaife]

Hi @Anwita 

If i understand your request i think this is what you're looking for. A Union tool set to Auto Config by Name, and Output Common Subset of Fields. Ensure that your 2nd table is the first input into the tool, followed by the second. This will then place all the data from the 1st table under the columns of the 2nd, and output where those columns exist in the 2nd table.

[Anwita]

But how is the order of columns being restored ? and i would need to show all 98 columns in the order in which it is present in 1st table along with data in all relevant columns from 2nd table

[DavidSkaife · Accepted solution]

Hi @Anwita 

Apologies, i mis-read your requirements! Tweaking it slightly, changing it to 1st dataset in then 2nd, still Auto Config by Name, and Output all Fields should do the trick!

[Anwita]

Thank you David, your solution worked like magic. Learning everyday ! :)