Merger columns from two different Csv into single Csv

[Ganshyam]

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

ID

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

[MS5]

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...?)

[Anonymous]

Hi

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

[Ganshyam]

Yes @Shicong Hong​ :

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

It worked .

Thanks

Ganshyam