Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Could you please help how to resolve below issue in QlikView Script?
Thanks,
Lawrance A
Hi Lawrance,
this is quite a simple piece of script. Please see the picture below
Hope this helps
Burkhard
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;
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