Help in Split one row into many rows

HJlassi1619437866 · ‎2021-06-11

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 · ‎2021-06-11

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

Send me Love and Kudos