Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...?)
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
Yes @Shicong Hong :
I created the sequence for 2 files and performed the join operation on this seqno ,
It worked .
Thanks
Ganshyam