topic Re: Transpose rows to cols in QlikView

Transpose rows to cols

Mon, 16 Jun 2014 11:59:30 GMT

Hi all,

I'm looking for a solution where I need to transpose a table from rows to columns. The example below works as intended, but I have about 400 ProdID's, any suggestions how to solve this in a smart way?

Thanks,

Jonas

OrgData:

load *Inline

[Knumber, ProdID, Value

1,6,1000

2,7,2000

3,8,3000

4,9,4000

5,10,5000

];

RowsToCols:

LOAD Knumber,

ProdID AS Prod1,

Value

RESIDENT OrgData

WHERE ProdID = '6';

CONCATENATE LOAD Knumber,

ProdID AS Prod2,

Value

RESIDENT OrgData

WHERE ProdID = '7';

CONCATENATE LOAD Knumber,

ProdID AS Prod2,

Value

RESIDENT OrgData

WHERE ProdID = '8';

// ProdID = 9, 10 e.t.c ...

DROP TABLE OrgData;

Re: Transpose rows to cols

swuehl — Mon, 16 Jun 2014 12:05:49 GMT

Have a look into GENERIC LOAD:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/31/generic

Re: Transpose rows to cols

MK_QSL — Mon, 16 Jun 2014 12:13:25 GMT

OrgData:

load *Inline

[Knumber, ProdID, Value

1,6,1000

2,7,2000

3,8,3000

4,9,4000

5,10,5000

];

Generic Load * Resident OrgData;

Drop Table OrgData;

Re: Transpose rows to cols

Mon, 16 Jun 2014 14:37:24 GMT

Hi Jonas, I just have a problem like that.

I suggest you to see:

- Option TANSPOSE acquiring data from external source (not inline)

- CROSSTABLE