Hlookup - copying columns from one datatset to another basis Hlookup

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 !

Help

Accepted answers

davidskaife

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!

Hlookup.yxmd

All comments

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.

Hlookup.yxmd

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

Anwita

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703