Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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.
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.
Ah, I remember what I did to this one, I loaded them Manually. Sorry for the wrong answer.