Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

salto
Valued Contributor II

Convert row in three rows

Hello Community!

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

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

RowNoTotaling
BS01002100|2200|2300

Into this one:

RowNoTotaling
BS01002100
BS01002200
BS01002300

Any help would be very appreciated.

Thanks in advance!

Tags (2)
1 Solution

Accepted Solutions

Re: Convert row in three rows

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

Something like below

Load

     RowNo,

     Subfield(Totalling,'|') AS Totallng

From.....

3 Replies

Re: Convert row in three rows

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

Something like below

Load

     RowNo,

     Subfield(Totalling,'|') AS Totallng

From.....

MVP
MVP

Re: Convert row in three rows

Load

          RowNo,

          SubField(Totaling, '|') as Totaling

From <>;

salto
Valued Contributor II

Re: Convert row in three rows

Many thanks to both of you!

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

Thanks again.

Community Browser