Help in Split one row into many rows

[HJlassi1619437866]

Hello, i have an urgent case that i need to split one row to multiple rows

in fact, i have as input :

id | code

1 | 12# 13# 14

2 | 15# 16

i need my output to be like that :

1 | 12

1 | 13

1 | 14

2 | 15

2 | 16

i appreciate your help and thank you in advance

[gjeremy1617088143]

Hi, maybe you could use tNormalize component with # as delimiter.

https://help.talend.com/r/q23BCE3W4MjloHD1RvMJ4A/AHFxuWix~gP8zzJM2oNGig

Send me Love and Kudos