Loop for reading Paradox files

fred_s — Thu, 03 Jan 2013 15:54:04 GMT

I have a few thousand Paradox DB files.
There is one file per day since May 2000, but only for the days on which the shop was open.
The files contain the sales for that day and they all have the same structure.

I've created a Paradox ODBC-DSN.

What I would like to do is Read all the files in One Qlikview file but unfortunately the Paradox driver can't handle wildcards.

This is how Qlikview handles the Paradox Select for file "Sales123100.DB":

SQL SELECT * FROM `C:\DATA`\sales123100;

For the available file names I've created a filenames.txt and loaded this in Qlikview.

Is there a way to read all of the files using a loop?

Thanks in advance

topic Loop for reading Paradox files in QlikView

Loop for reading Paradox files