Create duplicate columns using Talend

[Anonymous]

I have to generate a CSV file with duplicate columns, as required by an external partner. However when i define the output profile in the tMap that generates the output file, it does not allow me to specify a duplicate column (ie. another column with the same name). The external partner requires some of the column values duplicated since their system expects it that way.

How can i achieve this using TOS 6.5.1?

Thanks!

[akumar2301]

Usually it is external system which should duplicate data as per their requirement.
If you need to do , below is workaround:

Step 1 - create file with header as string e.g
“Id,name,name,amount”

Step 2- (your main job) append only data records without header

So final output will be
Id,name,name,amount
1,x,x,10.0

[Anonymous]

Thanks, this worked!

[akumar2301]

Gr8 can you please mark topic as resolved.