topic Re: Merger columns from two different Csv into single Csv in Talend Studio

Merger columns from two different Csv into single Csv

Ganshyam — Fri, 15 Nov 2024 23:52:41 GMT

Hello,

I am trying to merge columns from two different csv into single csv , there are no common columns between the two csv files

Source_Csv

-----------------------

Source

Name

Date

Destination_Csv

------------------------

Destination

ID_1

Name_1

Date_1

Merged_Csv

------------------------

Source | Destination

ID | ID_1

Name | Name_1

Date | Date_1

I tried tmap option , but no luck, any other workaround?

Regards

Re: Merger columns from two different Csv into single Csv

MS5 — Mon, 09 Aug 2021 15:51:05 GMT

Hello,

How do you know which record of the first file and which record of the second file have to be merged? on the row ID? (first line with first line, second line with second line...?)

Re: Merger columns from two different Csv into single Csv

Anonymous — Tue, 10 Aug 2021 01:32:08 GMT

if there is no row ID, add a new column and add a sequence id to each row using the expression:

Numeric.sequence("s1",1,1)

Note that the sequence name should be different for each data source.

Regards

Shong

Re: Merger columns from two different Csv into single Csv

Ganshyam — Tue, 10 Aug 2021 13:46:51 GMT

Yes @Shicong Hong :

I created the sequence for 2 files and performed the join operation on this seqno ,

It worked .

Thanks

Ganshyam