transpose

[raadwiptec]

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]

May be as below:

[raadwiptec]

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]

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),

Rotate(left)

));

Thanks & Regards

Sumeet

[Anonymous]

You can achieve it in Pivot Table

[devarasu07]

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]

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