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

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,

Tips and Tricks

Common Use Cases

Accepted answers

Garabujo7

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

All comments

Garabujo7

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703