topic merge column csv in Talend Studio

merge column csv

Anonymous — Sat, 16 Nov 2024 07:48:14 GMT

Hello,

I am new to the software Talend (1 month and a half) and I am opposed to a problem today.
I have 2 csv file and I want them together knowing that they do not have the same schema. (but the same number of lines).
I would like to copy the columns of one for the meters in the other (or a new file).

If you have any leads or solutions, I'm interested.

Thank you in advance,
Regards,
Fabien.

Re: merge column csv

Mark11 — Fri, 17 Aug 2018 15:33:13 GMT

is there a shared key between the 2 csvs that you can join them on?

You can use a TMap to merge these files on that key - so in my example, col1 from the first csv file (row1) is common with colA on the second (row2):

Hope this helps

Mark

Re: merge column csv

Anonymous — Mon, 20 Aug 2018 13:08:49 GMT

Great !
I don't know this fonctionnality, Thank you !

Regards,
Fabien.