topic Help how onto transpose single column table using the edit script ? in QlikView

Help how onto transpose single column table using the edit script ?

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

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 .

Re: Help how onto transpose single column table using the edit script ?

martinpohl — Tue, 18 Jun 2019 13:23:00 GMT

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;

Re: Help how onto transpose single column table using the edit script ?

prahlad_infy — Tue, 18 Jun 2019 13:29:06 GMT

Thanking you sir

Re: Help how onto transpose single column table using the edit script ?

Frank_Hartmann — Tue, 18 Jun 2019 13:36:58 GMT

you can use a pivot table and drag the Column Field to the upper right until the blue horizontal line appears.
Not neccessary to change the script in this case but if so, you can use the transpose function in File Wizard (Enable Transformation Step --> Rotate-->Transpose). This will generate you a separat Column for each Field!