Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please could you help me split string into multiple row with space.
example below.
input
ID description
a123 abc def ghi
b123 abc def ghi jkl
output
ID Description
a123 abc
a123 def
a123 ghi
b123 abc
b123 def
b123 gfh
b123 ijk
Regards
Take a look at the tNormalize component. That will solve this problem for you. Here are instructions: https://help.talend.com/reader/g8zdjVE7fWNUh3u4ztO6Dw/PCoAqHiZrLEYPgz5Byu7XQ
Take a look at the tNormalize component. That will solve this problem for you. Here are instructions: https://help.talend.com/reader/g8zdjVE7fWNUh3u4ztO6Dw/PCoAqHiZrLEYPgz5Byu7XQ