How to add column headers from another file

[sharmilaj]

Hi all,

Is there a way to add just headers from another excel file for which data will be populated later in Alteryx. Other than using the formula add columns because I have lot of headers. 

Kindly help build flow for the below. Thanks.!

For example.

Existing data

NAME	DOB	AGE
A	1991	31
B	1993	29
C	1995	27

Header from another file

JANUARY

FEBRUARY

MARCH

APRIL

MAY

JUNE

JULY

AUGUST

SEPTEMBER

OCTOBER

NOVEMBER

DECEMBER

Expected result

NAME

DOB

AGE

JANUARY

FEBRUARY

MARCH

APRIL

MAY

JUNE

JULY

AUGUST

SEPTEMBER

OCTOBER

NOVEMBER

DECEMBER

A

1991

31

B

1993

29

C

1995

27

[Luke_C · Accepted solution]

Hi @sharmilaj 

The crosstab and append fields tools should do the trick. I did have to add an empty column to your month list to get it to work.