Fill a template with input data

omar_velor

Hello all,

I have a blank csv file (template) with headers that I want to fill according to different csv files.

After importing the blank csv file I have a table like this, 

ID	Country	Weight	Height	Age	Language	Passport

One if the input files I have looks like this, 

ID	Age	Passport
1	31	y
2	32	y
3	33	n
4	34	y

I am wondering if you could give me a hand with the workflow that would generate the following output,

ID	Country	Weight	Height	Age	Language	Passport
1				31		y
2				32		y
3				33		n
4				34		y

I need to keep all columns, even if all entries are blank.

I have been using the Join block to achieve the goal but it is not working - I am definitely doing something wrong.

Any suggestions will be quite appreciated.

Kenda

@omar_velor 

Have you tried using the Union tool instead of the join? Use your blank csv file with the headers as the first connection coming into the Union