Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I received xls files, and these files have many sheets. Last sheet in file is incorrect. How ignore this sheet?
Hi,
How are you loading all the sheet of workbook?
Regards
KC
Hi,
go through this:
http://community.qlik.com/docs/DOC-4452
In this simply ignore the last sheet from the loop and try to number your sheets as 1,2,3.....
Regards
KC
I use following loop
FOR j=0 TO NoOfRows('tables')-1
.
.
.
.
Next j
Hi,
Simply make it :
FOR j=0 TO NoOfRows('tables')-2
.
.
.
.
Next j
So it will ignore the last sheet. give it a try.
Regards
KC