Looping a list of documents

[#1]

Hi,

I have to set up a loop using the ODBC connector which goes through all files in a folder and takes the data from each of them consequently ( more details in the file itself below ) I have used Qlikview components to create an internal list for the files, but I don't know how can I join it to the main body ( In the tab called Main 6 I have the script which is somehow supposed to help it but I cant figure it out

Availability_check:

NoConcatenate

LOAD

[File Path],

ID_row_no

RESIDENT Qvc.ListFilesTable;

let vCounter = fieldvaluecount('ID');

for  ID_row_no = 1 to vCounter

let  v = FieldValue('[File Path]',$(ID_row_no));

let  a = $(ID_row_no);

//main:

//LOAD $(*name) as ID,

[Miguel_Angel_Baeyens]

Hi,

Take a look at the script code in this thread.

Hope that helps.

Miguel

[rwunderlich]

I'm not quite following your example. Do you want to execute the script on the balance tab for each file?

-Rob