Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Use below in script
Subfield(Totalling,'|') AS Totallng
Something like below
Load
RowNo,
Subfield(Totalling,'|') AS Totallng
From.....
Use below in script
Subfield(Totalling,'|') AS Totallng
Something like below
Load
RowNo,
Subfield(Totalling,'|') AS Totallng
From.....
Load
RowNo,
SubField(Totaling, '|') as Totaling
From <>;
Many thanks to both of you!
I only could mark the first one as correct, but both are perfect.
Thanks again.