Talend Extract dynamic input and transpose it

Question

I have an input flow with dynamic number of values in column :

678|32;29;29;46;48

094|2;8;9;9;48;48

the final result I need :

678|32

678|29

678|46

678|48

094|2

094|8

094|9

094|48

Should I use tjava to parse this flow and how to unpivot dynamically to rows?

Thanks

Answer 1

I founed a Talend component that give me the right output, it is tNormalize

It take as input the column to normalise and split it dynamically and transpose the spitted values to rows.

thank you guys