how to join two sheets into one sheet and rename header with sheet2 header?

[phoebe_90]

1.join two sheets into one sheet 

2.rename header with sheet2 header

3.sort by document number

sheet1

Document Number	Input_#2_Account	Amount in local currency	Input_#2_Cost Center	Input_#2_Profit Center	Tax Code
19000498	66020000	0.45	7061	601	J2
19000477	65040000	376.42	7095	902	J1
19000477	65010000	350.28	7095	902	J2
19000477	65010000	350.28	7095	902	J2
19000477	65010000	360.89	7095	902	J2
19000471	66020000	8.49	7093	901	J2
19000498	66020000	107.1	7061	601	J1
19000471	66020000	191.44	7093	901	J1

sheet2

Document Number	Account	Amount in local currency	Cost Center	Profit Center	Tax Code
19000498	24508210	0.45		900	J2
19000477	24508210	376.42		900	J1
19000477	24508210	1061.44		900	J2
19000471	24508210	8.49		900	J2
19000498	24508210	107.1		900	J1
19000471	24508210	191.44		900	J1

[Luke_C]

Hi @phoebe_90 

Sounds like you'd want to use the Union tool followed by a sort tool. To keep the 2nd set of headers connect that data to the tool first (or set the order in the configuration)

https://help.alteryx.com/20223/designer/union-tool

[gautiergodard]

Agreed with @Luke_C - something like the attached workflow should work.

If needed, you could also use the field info tool combined with a dynamic rename.