Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
bobbydave
Creator III
Creator III

Not looping to 2nd page

I have a mapping table and I want to look into all sheets on the mapping table.

Below is the code.

//Loop through Mapping table sheets to pick up IP address and produce whether Active servers
ODBC CONNECT TO [Excel Files;DBQ=$(vMapping)\Qualys_CMDB.xlsx];
Sheets:
SQLTABLES;
DISCONNECT;
for i = 0 to FieldValueCount('TABLE_NAME') -1
Let vTablename = Left(Peek('TABLE_NAME',$(i)),len(Peek('Sheets',$(i)))-1);

Qualys_CMDB_Status:
Mapping
LOAD
     [IP Address], 
     Status
FROM
[$(vMapping)\Qualys_CMDB.xlsx]
(ooxml, embedded labels, table is [$(vTablename)]);
//loop through sheets
Next i;
DROP Table Sheets;

From looking at the script execution, its giving me the same page twice

Pic attached.

 

Any ideas why it doesn't show Page 2 on the script execution?

Labels (3)
1 Solution

Accepted Solutions
bobbydave
Creator III
Creator III
Author

Page 1 is 32000
Page 2 is 13456

View solution in original post

1 Reply
bobbydave
Creator III
Creator III
Author

Page 1 is 32000
Page 2 is 13456