Which Join Function to use to combine Columns into a template with headers.

[datadabbler]

I have a CSV (left) line spreadsheet with Headers (approx 50 headers). I have another CSV (right) with filled columns (approx 20, with headers). I need to combine both so that Left populates Right with the columns data. Which function should I be using for this?

Thanks,

S

[Garabujo7 · Accepted solution]

Hello @datadabbler , you could use a Union.

First input would be the headers, second the data.

Use the option Auto config by position for this.

Gabriel

[npariso]

Hi @datadabbler are there any common columns between the two different data sources?

[grazitti_sapna]

Hi @datadabbler , I am not sure if I completely understood your problem, but in case you have something in common in both data sets then you can join the data on basis of that field otherwise please use Append tool to get data from both data sets in one view without join and select the columns you want from both data sets. If you want to blend the data then u can use Union and manually configure the fields if names are different.

[datadabbler]

Apologies, I should have mentioned there are common columns (+ others I have renamed to have common columns using the select tool).

[datadabbler]

This worked perfectly, thank you.