topic Re: Transpose columns information in QlikView

Transpose columns information

Wed, 05 Mar 2014 23:11:52 GMT

Hi all, I have a table with the following structure

specialitemprice specialitemquantity name price quantity

23 7 abc 34 5

23 7 ddd 22 3

23 7 eee 77 2

23 7 fff 222 8

And I would like to convert it to:

name price quantity

abc 34 5

ddd 22 3

eee 77 2

fff 222 8

special_item 23 7

i.e. create "manually" a new row containing specialitem info (name will be hardcoded)

Any hint?

Thanks!

Re: Transpose columns information

swuehl — Wed, 05 Mar 2014 23:17:16 GMT

Maybe

Table:

LOAD name,

price,

quantitiy

FROM YourTable;

LOAD 'special_item' as name,

specialitemprice as price,

specialitemquantity as quantity

FROM YourTable where recno() = 1;

Re: Transpose columns information

rwunderlich — Wed, 05 Mar 2014 23:19:13 GMT

How about:

Final:

LOAD

name, price, quantity

from source;

Concatenate (Final)

LOAD DISTINCT
specialitemprice as name,

specialitemquantity as quantity

from source;

-Rob

http://mastersummit.com

http://robwunderlich.com

Re: Transpose columns information

MarcoWedel — Wed, 05 Mar 2014 23:35:50 GMT

Hi Frijolita,

one possible solution for your problem could be:

tabPrices:

Load * Inline [

specialitemprice,specialitemquantity,name,price,quantity

23,7,abc,34,5

23,7,ddd,22,3

23,7,eee,77,2

23,7,fff,222,8

];

Concatenate

LOAD Distinct

'special_item' as name,

specialitemprice as price,

specialitemquantity as quantity

Resident tabPrices;

DROP Fields specialitemprice,specialitemquantity;

which turns this table

into this

hope this helps

regards

Marco