Looping a list of documents

Thu, 26 Jul 2012 08:19:25 GMT

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,

Re: Looping a list of documents

Miguel_Angel_Baeyens — Thu, 26 Jul 2012 11:53:10 GMT

Hi,

Take a look at the script code in this thread.

Hope that helps.

Miguel

Re: Looping a list of documents

rwunderlich — Thu, 26 Jul 2012 21:26:09 GMT

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

-Rob

topic Re: Looping a list of documents in QlikView

Looping a list of documents

Re: Looping a list of documents

Re: Looping a list of documents