merge column csv

[Anonymous]

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.

[Mark11 · Accepted solution]

Hi

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

[Anonymous]

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

Regards,
Fabien.