add columns into a file by key

[SCASANOVA1607023480]

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!!!

[Anonymous]

Hi

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