Split columns into multiple columns

[joe86]

Hi All,

I have a situation here. I have a data set like below:

This data set was obtained using

MsSQLInput-->tmap-->tSortRow-->tDeNormaliseSortedRows-->tMap-->tExcelOutput.

Now as per the new requirement, i have to split this "EmpID" & "EmpName" columns to multiple columns.

In this case I should have 3 EmpID columns and 3 EmpName columns. It basically depends on how many.

Can some one please suggest me to do this.

I tried doing with tNormalise, but it didnt work. Alos tried my luck with "tExtractDelimitedFiles" as below:

MsSQLInput-->tmap-->tSortRow-->tDeNormaliseSortedRows-->tMap-->tExtractDelimitedFiles-->tExcelOutput.

Here i was able to select only 1 column to split and this also didn't get me the exact answer.

My final output should be like below

[Anonymous]

@MNK_2019 

I have answered your query in the below post. Request you to lease keep your query to single post 🙂 

https://community.talend.com/t5/Design-and-Development/Split-and-Interchange-string-text/m-p/164212#...

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Psade1606751688]

Hi Team I have products like below.

 

Is there any possibility to split into deafferent rows.