Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Sirs ,
Help how onto transpose using the script ?
I am have only one column in a table , there are no other column .
Thanking You Sirs .
Here you go, but there are no datas in table:
Data:
LOAD * INLINE [
Column
Field1
Field2
Field3
Field4
];
FinalData:
LOAD * INLINE [
F1
];
let vRows = NoOfRows('Data')-1;
for vLoop = 0 to $(vRows);
let vField = peek('Column',$(vLoop),'Data');
left join (FinalData) load
'$(vField)' as "$(vField)"
AutoGenerate 1;
next
drop field F1 from FinalData;
Here you go, but there are no datas in table:
Data:
LOAD * INLINE [
Column
Field1
Field2
Field3
Field4
];
FinalData:
LOAD * INLINE [
F1
];
let vRows = NoOfRows('Data')-1;
for vLoop = 0 to $(vRows);
let vField = peek('Column',$(vLoop),'Data');
left join (FinalData) load
'$(vField)' as "$(vField)"
AutoGenerate 1;
next
drop field F1 from FinalData;