topic Re: transpose in QlikView

transpose

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

I have the following table.

GName GValue userid

G1 100 xxxx

G2 31 yyyy

G3 67 dddd

G4 95 nnnn

i need the following output below

G1 G2 G3 G4

100 31 67 95

xxxx yyyy dddd nnnn

trdandamudi — Fri, 08 Dec 2017 15:57:20 GMT

May be as below:

raadwiptec — Mon, 11 Dec 2017 08:41:15 GMT

Hi,

I dont want to do this in an expression or in the front. I would like to achive this in the script.

sumeet-vaidya — Mon, 11 Dec 2017 08:56:33 GMT

Hi,

Kindly use the below code.

LOAD G4,

G3,

G2,

G1,

Gname

FROM

[..\Desktop\Test.xlsx]

(ooxml, embedded labels, table is Sheet1, filters(

Rotate(left),

Rotate(left)

));

Thanks & Regards

Sumeet

Anonymous — Mon, 11 Dec 2017 09:05:20 GMT

You can achieve it in Pivot Table

devarasu07 — Mon, 11 Dec 2017 09:20:28 GMT

Hi,

also u can use right rotate instead of left while loading your source as excel file and enable transformation

Fact:
LOAD G4,
    G3,
    G2,
    G1,
    Gname
FROM

(ooxml, embedded labels, table is Sheet1, filters(
Rotate(right)

trdandamudi — Mon, 11 Dec 2017 10:56:15 GMT

Have you taken a look at the attached file? It is all done in the script and not in the front end.