topic Re: Convert column values to rows based on another column in QlikView

Convert column values to rows based on another column

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have just started working on Qlikview scripting where I need to convert a single column to rows based on another column.

Input:

Here, i need to convert Value column into Rows based on Rowno

Output:

Can anyone help me on this?

Thanks

Praveena

Re: Convert column values to rows based on another column

Frank_Hartmann — Tue, 11 Sep 2018 19:02:33 GMT

Script:

LOAD * INLINE [

Value, Rowno

/, 1

2, 1

20180821, 1

/, 2

4, 2

20180822, 2

/Collection, 3

8, 3

20180821, 3

];

Straight Table:

Dim:

Rowno

Expression1 (Label=col1):

subfield(Concat(Value,',',Value),',',3)

Expression2 (Label=col2):

subfield(Concat(Value,',',Value),',',1)

Expression3 (Label=col3):

subfield(Concat(Value,',',Value),',',2)

On Presentation Tab you can hide Dimension

Output:

Re: Convert column values to rows based on another column

MarcoWedel — Tue, 11 Sep 2018 19:26:19 GMT

Hi,

one solution could be:

table1:

Generic

LOAD Rowno,

'Col'&AutoNumber(RowNo(),Rowno),

Value

Inline [

Value, Rowno

/ , 1

2 , 1

20180821 , 1

/ , 2

4 , 2

20180822 , 2

/Collection, 3

8 , 3

20180821 , 3

];

Re: Convert column values to rows based on another column

Anonymous — Wed, 12 Sep 2018 06:31:37 GMT

Thankyou Marco

It worked.