How to copy column name to first row?

[JJJJC]

How can I copy column names of a table to first row so that when I try to stack (union) it with another table on same excel sheet, I can still see the column names?

[Emil_Kos]

Hi @JJJJC,

Legendary @MarqueeCrew wrote a post about an elegant and simple solution to achieve it!

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Column-headers-as-first-row-of-data/m-...

[atcodedog05]

Hi @JJJJC 

Can you sample input and expected output.

Edit: @Emil_Kos yup my approach would also be similar 😅

[JJJJC]

input1:

header1	header2
A	1
B	2

input2:

header3	header4
x	3
z	4

expected output:

header1	header2
A	1
B	2
header3	header4
x	3
z	4

Currently, when I try to union the two table by position, I would lose header3 and header4.

[atcodedog05 · Accepted solution]

Hi @JJJJC 

Here is how you can do it.

Workflow:

Hope this helps : )

[JJJJC]

Thank you both! 

[atcodedog05]

Happy to help : ) @JJJJC 

Cheers and have a nice day!