topic add columns into a file by key in Talend Studio

add columns into a file by key

SCASANOVA1607023480 — Sat, 16 Nov 2024 01:00:31 GMT

Hi! I'd like to know how can I add some columns into a file, I have this :

date,country,mesure1

12-01-2020,FR,0.1

date,country,mesure2

12-01-2020,FR,2

12-02-2020, FR,3

And I'd like to get something like :

date,country,mesure1,mesure2

12-01-2020,FR,0.1,2

12-02-2020,FR,null,3

Thanks!!!

Re: add columns into a file by key

Anonymous — Fri, 04 Dec 2020 08:08:35 GMT

If the data are in the same file, you can try tDenomalize component. You need to remove the column lines before tDenomralize if the file contains column lines.

Please make some testing and let me know if you have any problems.

Regards

Shong