Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be as below:
Hi,
I dont want to do this in an expression or in the front. I would like to achive this in the script.
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
You can achieve it in Pivot Table
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)
Have you taken a look at the attached file? It is all done in the script and not in the front end.