Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lawrance
Creator II
Creator II

Change Rows into Column in QliKView

Hi All,

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

Sample.png

Thanks,

Lawrance A

3 Replies
veidlburkhard
Creator III
Creator III

Hi Lawrance,

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

TestTable.jpg

Hope this helps

Burkhard

adityaakshaya
Creator III
Creator III

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;

petter
Partner - Champion III
Partner - Champion III

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