Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
bobbydave
Contributor 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?

1 Solution

Accepted Solutions
bobbydave
Contributor III

Re: Not looping to 2nd page

Page 1 is 32000
Page 2 is 13456
1 Reply
bobbydave
Contributor III

Re: Not looping to 2nd page

Page 1 is 32000
Page 2 is 13456