Help in Split one row into many rows

HJlassi1619437866 — Fri, 11 Jun 2021 14:30:31 GMT

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

Re: Help in Split one row into many rows

gjeremy1617088143 — Fri, 11 Jun 2021 15:31:00 GMT

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

Send me Love and Kudos