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

[Tej_Singh]

Hi All,

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

Name	2/1/2021	2/4/2021	2/5/2021	2/8/2021
A	1
B	2
C	3
A		4
B		5
C		6
D		7
A			8
B			9
C			10
A				11
B				12
C				13

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

Name	2/1/2021	2/2/2021	2/3/2021	2/4/2021	2/5/2021	2/6/2021	2/7/2021	2/8/2021	2/9/2021	2/10/2021
A
B
C
D

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

Name	2/1/2021	2/2/2021	2/3/2021	2/4/2021	2/5/2021	2/6/2021	2/7/2021	2/8/2021	2/9/2021	2/10/2021
A	1			4	8			11
B	2			5	9			12
C	3			6	10			13
D				7

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?

[Assaf_m · Accepted solution]

Check Attached Solution

let me know if this helps.

[Qiu · Accepted solution]

@Tej_Singh 

Try this

[Tej_Singh]

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