Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I load from different folders?

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?









1 Reply
Not applicable
Author

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