topic How can I load from different folders? in QlikView

How can I load from different folders?

Thu, 02 Sep 2010 13:39:37 GMT

I need to load file with the same name from different folders

I thought I could write:

S:\ds\GTT\*\Exporttabell.xls

the folders are for example:

S:\ds\GTT\one\Exporttabell.xls

S:\ds\GTT\two\Exporttabell.xls

S:\ds\GTT\three\Exporttabell.xls

How can I manage to solve this?

Thu, 02 Sep 2010 13:56:12 GMT

I think you can use * (0 or n char) and ? (one char) symbols in your load instruction :

1) first build your load instruction on one file (using wizard if needed),

2) replace the folder name by *


LOAD F1,
 F2
FROM

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

hopes it helps

best regards