I have a for loop, looping through and connecting to different databases which it reads from an excel file and concatenating the info in a table. After it runs through each connection with a different db, at the end of the last one the reload stops but the close button does not populate. When I click End here it will freeze my qlikview and I have to end task it.
Any help would be great.
I think its just extracting I didn't do a store statement.
Here is my code..
(ooxml, embedded labels, table is Sheet1);
// fill variable with field values row by row
For i = 0 To NoOfRows('QCProjects')-1
let vDatabaseName=peek('DatabaseName', $(i),'QCProjects');
let vProjectName=peek('ProjectName', $(i),'QCProjects');
trace $(vDatabaseName) $(vProjectName);
// .......... use connection string
OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=BI_QLIKVIEW;Initial Catalog=$(vDatabaseName);Data Source=SDBQCV1P;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=OPT0022;Use Encryption for Data=False;Tag with column collation when possible=False] (XPASsword is BLANK);
Let vDefectsTableName = 'Defects'; // Define Table Name
// Load everything in to table variable
// Get information from Table in database
SELECT '$(vProjectName)' AS ProjectName, bud.*
FROM td.BUD as bud;