topic load files with a loop in QlikView

load files with a loop

Tue, 21 Jul 2009 13:55:01 GMT

hello guys,

I search the forums for an example but I didn't find one.

I have a directory ( named C:\test ) which contains 3 XLS files named ACT1,ACT2,ACT3.

All 3 files are in the same structure.

All I want is to build a loop which will run 3 times and will load the files.

How can I do that?

What is the correct syntax ?

Thanx a lot!

David

load files with a loop

Tue, 21 Jul 2009 14:01:48 GMT

Hi David,

you can use a wild card:

Load

Field1,

Field2,

Field3

FROM ACT*.xls (biff, embedded labels, table is Tabelle1$);

Good luck!

Rainer

load files with a loop

Tue, 21 Jul 2009 14:02:08 GMT

Hi David,

Here is an example that loads a spreadsheet with multiple sheets. The theory should also work for what you want to do.


SET vPath=C:\Training\;
for vSheetName = 2005 to 2009
 "BUDGETS":
 LOAD
 EmployeeID,
 $(vSheetName) AS BUDGETYEAR,
 Budget as BUADGETAMOUNT
 FROM [$(vPath)\Datasources\Budget.xls] (biff, embedded labels, table is [$(vSheetName)$],FILTERS(REPLACE(1,TOP,STRCND(NULL))));
next

Regards,

Werner

load files with a loop

Tue, 21 Jul 2009 15:46:24 GMT

Great (and really quick) solutions!

10X guys

load files with a loop

Tue, 21 Jul 2009 16:01:09 GMT

A really simple example of a loop:

For I = 1 to 3

LOAD F1,
F2,
F3
FROM

(biff, embedded labels, table is Sheet1$);

Next I