topic Re: Need to parse delimited column to multiple row in Talend Studio

Need to parse delimited column to multiple row

Anonymous — Thu, 07 Mar 2019 12:17:57 GMT

Hello,

Recently, I am started using talend and I have requirement to achieve the below result. Can someone please help me?

3rd columns have a delimiter with one or more values. I want to normalise these input.

Input file
----------

100,Jay,abc;ijk;xyz,1
200,Jack,abc;ijk,2
300,James,abc,3

Expected Output
---------------
100,Jay,abc
100,Jay,ijk
100,Jay,xyz
200,Jack,abc
200,Jack,ijk
300,James,abc

Re: Need to parse delimited column to multiple row

akumar2301 — Thu, 07 Mar 2019 12:24:06 GMT

tNormalise

https://help.talend.com/reader/hm5FaPiiOP31nUYHph0JwQ/AHFxuWix~gP8zzJM2oNGig

Normalise 3rd Column with separator ";"

Re: Need to parse delimited column to multiple row

Anonymous — Thu, 07 Mar 2019 12:25:11 GMT

Hi,

Below link is having similar use case and it is having two Talend community links where its already resolved.

Could you please try them?

https://community.talend.com/t5/Design-and-Development/How-to-normalize/m-p/153544#M93818

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 🙂

Re: Need to parse delimited column to multiple row

Anonymous — Thu, 07 Mar 2019 12:26:10 GMT

@uganesh

Sorry Abhi. Seems we have posted around same time 🙂

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 🙂