Convert row in three rows

[salto]

Hello Community!

Long time no see... hope you all are well.

I have this question: I need to convert this table:

RowNo	Totaling
BS0100	2100|2200|2300

Into this one:

RowNo	Totaling
BS0100	2100
BS0100	2200
BS0100	2300

Any help would be very appreciated.

Thanks in advance!

[MK_QSL · Accepted solution]

Use below in script
Subfield(Totalling,'|') AS Totallng

Something like below

Load

     RowNo,

     Subfield(Totalling,'|') AS Totallng

From.....

[tresesco]

Load

          RowNo,

          SubField(Totaling, '|') as Totaling

From <>;

[salto]

Many thanks to both of you!

I only could mark the first one as correct, but both are perfect.

Thanks again.