Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to load multiple DBF file in loop?

Please help me get through this, I have different DBF files (different filename per se)... Is it possible to load it in loop? Or give me ideas how to solve this problem. Thanks.

Best regards

4 Replies
Highlighted
Not applicable

Any update on this? I have similar requirements: Multiple DBF files (one per day; log files from a daily tracking software)

It's not really feasable for me to create an ODBC connection for each file and it certainly isn't forward-looking.

Any input from the community about a solution for this?

Highlighted
Not applicable

You can use wildcard

Say,

C:\Qlikview\Employee20*.dbf

So, all .dbf that has Employee20 will all be loaded. Just make sure that it has the same format on the fields.

Highlighted
Not applicable

Hi billringer,

Unfortunately the wildcard approach doesn't seem to work for DBF files, which need to be loaded using an ODBC connection. In order to load these you must first create an ODBC connection pointing toward specific DBF files.

If Qlikview could build native DBF loading, we could probably use a wildcard approach like you've described, but I think as long as we have to go via the ODBC route, we'll need to look into another solution.

Highlighted
Not applicable

Ah, I remember what I did to this one, I loaded them Manually. Sorry for the wrong answer.