Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

Need to parse delimited column to multiple row

Highlighted
Four Stars

Need to parse delimited column to multiple row

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


Accepted Solutions
Highlighted
Eleven Stars

Re: Need to parse delimited column to multiple row

tNormalise

 

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

 

Normalise 3rd Column with separator ";"

 

 

Regards
Abhishek KUMAR

View solution in original post

Highlighted
Employee

Re: Need to parse delimited column to multiple row

@akumar2301 

 

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 :-)

View solution in original post


All Replies
Highlighted
Eleven Stars

Re: Need to parse delimited column to multiple row

tNormalise

 

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

 

Normalise 3rd Column with separator ";"

 

 

Regards
Abhishek KUMAR

View solution in original post

Highlighted
Employee

Re: Need to parse delimited column to multiple row

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 :-)

Highlighted
Employee

Re: Need to parse delimited column to multiple row

@akumar2301 

 

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 :-)

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog