Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Tags (2)
4 Replies
Not applicable

Re: How to load multiple DBF file in loop?

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?

Not applicable

Re: How to load multiple DBF file in loop?

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.

Not applicable

Re: How to load multiple DBF file in loop?

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.

Not applicable

Re: How to load multiple DBF file in loop?

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