Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?