topic Re: How to load multiple DBF file in loop? in QlikView

How to load multiple DBF file in loop?

Fri, 24 Feb 2012 04:14:30 GMT

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

Re: How to load multiple DBF file in loop?

Wed, 01 Aug 2012 09:52:43 GMT

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?

Re: How to load multiple DBF file in loop?

Wed, 01 Aug 2012 10:07:20 GMT

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.

Re: How to load multiple DBF file in loop?

Wed, 01 Aug 2012 10:14:50 GMT

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.

Re: How to load multiple DBF file in loop?

Wed, 01 Aug 2012 10:17:50 GMT

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