I've a problem loading in Qlikview particular codes from a dBase file.
The script I'm using is very simple:
ODBC CONNECT32 TO [dBase Files];
SQL SELECT *
Some fields in the source DBF file use a particolar coding system in which, for example, '52', '052', '0052' are three completely different codes. Qlikview seems to fail to load correctly these values, randomly adding or removing inital '0' digit, for example:
code '0042' becomes '042' and code '539' becomes '0539'.
I've tried to change the ODBC driver (MS Access dBase Driver v. 15) with an OLEDB driver (Visuale FoxPro) but the problem still remains; using the same ODBC driver in excel the values are loaded correctly so it isn't a bug of the driver and the original dfb file isn't damaged.
How can I force Qlikview to load these values without trying to alter/modify/interpret anything?