Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have table like
table1 this is field name
d1
d2 this are sub fields
d3
I want to get it like
table d1 d2 d3
implementation done in scripting side not in ui side.
plz help me.
crosstable
this table is converted from crosstable format to column format.
crosstable
this table is converted from crosstable format to column format.
That sounds like you need a generic load, see below link for an explanation:
Data
Transformation:
To:
Script:
Directory;
CrossTable(A, Data)
LOAD Tab1,
A,
B,
C
FROM
CROSSTA.xlsx
(ooxml, embedded labels, table is Sheet1);