Joining data by Column name between the output and table headers into an excel

Hi All,

I have the following data output from Batch macro: (Data worksheet in attached file)

Have the following monthly output template: (Template worksheet in attached file)

I want to create the following output based on the column names between the macro output and template

Can this be made dynamic such that for next month my column names changes in both output and Template to say 3/1/2021 and so on it should still work?

Can anyone suggest how to achieve this in Alteryx Designer?

Developer

Output

Batch Macro

Join

Accepted answers

Check Attached Solution

let me know if this helps.

Try this

Check Attached Solution

let me know if this helps.

Try this

It definitely helped @Assaf_m and @Qiu Both the solutions worked perfectly for me! Thank you both. 🙂