topic Re: Convert row in three rows in QlikView

Convert row in three rows

salto — Thu, 24 Apr 2014 08:17:42 GMT

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:

Any help would be very appreciated.

Thanks in advance!

MK_QSL — Thu, 24 Apr 2014 08:18:32 GMT

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

Something like below

Load

RowNo,

Subfield(Totalling,'|') AS Totallng

From.....

tresB — Thu, 24 Apr 2014 08:19:14 GMT

Load

RowNo,

SubField(Totaling, '|') as Totaling

From <>;

salto — Thu, 24 Apr 2014 08:25:27 GMT

Many thanks to both of you!

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

Thanks again.