topic Create duplicate columns using Talend in Talend Studio

Create duplicate columns using Talend

Anonymous — Sat, 16 Nov 2024 06:22:52 GMT

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!

Re: Create duplicate columns using Talend

akumar2301 — Fri, 08 Mar 2019 20:48:10 GMT

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

Re: Create duplicate columns using Talend

Anonymous — Sat, 09 Mar 2019 20:53:03 GMT

Thanks, this worked!

Re: Create duplicate columns using Talend

akumar2301 — Sat, 09 Mar 2019 20:57:40 GMT

Gr8 can you please mark topic as resolved.