topic Change Rows into Column in QliKView in QlikView

Change Rows into Column in QliKView

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

Hi All,

Could you please help how to resolve below issue in QlikView Script?

Thanks,

Lawrance A

Re: Change Rows into Column in QliKView

veidlburkhard — Tue, 05 Jun 2018 19:14:33 GMT

Hi Lawrance,

this is quite a simple piece of script. Please see the picture below

Hope this helps

Burkhard

Re: Change Rows into Column in QliKView

adityaakshaya — Tue, 05 Jun 2018 19:15:13 GMT

Hi Lawrance,

Please find attached sheet and application for your reference.

Here is the code if you are using personal edition.

Let me know for any further clarification.

Regards,

Akshaya

PS - if you find this solution as correct and helpful, mark it as correct/helpful.

//*************************************************************************************************************

ODBC CONNECT32 TO [Excel;DBQ=C:\Users\Akshaya\Documents\Test\Test.xlsx];

Cols_Temp:

SQLCOLUMNS;

ColumnNo:

Load max(ORDINAL) as MaxOrdinal Resident Cols_Temp;

Let vLoop = Peek('MaxOrdinal',0,ColumnNo)/2-1;

Drop Table Cols_Temp;

Drop Table ColumnNo;

Test:

SQL Select ID,Name from `C:\Users\Akshaya\Documents\Test\Test.xlsx`.`Sheet1$`;

For i = 1 to $(vLoop)

SQL select ID$(i) as ID, Name$(i) as Name from `C:\Users\Akshaya\Documents\Test\Test.xlsx`.`Sheet1$`;

Next i;

Re: Change Rows into Column in QliKView

petter — Fri, 29 Jun 2018 14:26:51 GMT

If the question has been answered please mark the right response as CORRECT and if you feel like it give all the persons that were helpful a HELPFUL tag on their responses too.

Thanks