Discussion Board for collaboration on QlikView Scripting.
Has anyone else experienced the same behaviour in a Qlikview 11 / ODBC 6.1.7601 environement ?
We access data thru ODBC (target database being DB2 on AS/400).
In the tabel, a text field FIELD1 can contain the follow values: 000301160100030116010003011600030456etc.
The data are loaded to Qlikview thru the following command:
Load FIELD1 ;SQL Select FIELD1 from table ;
Once the data are loaded, some of the leading zeroes are lost:
03011601 (instead of 0003011601)03011601 (instead of 0003011601) 0003011600030456
This of course causes data integrity issues.
We have implemented a workaround as follows:
Load REPLACE(FIELD1, '#','') as FIELD1 ; SQL Select '#' || FIELD1 || '#' as FIELD1 from table;
But we are afraid that this same problem has occurred on other tables and other fields.
If someone else has experienced this behaviour, is there a better workaround ?
Thanks in advance for any help or opinion.
This should work in that case.
Load Text(FIELD1) as FIELD1 ;SQL Select FIELD1 from table ;