When loading data from a databases, I have a table with my articles which each have a unique itemno, which is alfa-numerical (character).
In my database, I have an item with itemno "850" and one with itemno "00850".
When loading this into QlikView (qvd files), QlikView loads them both as "00850", and thereby eveyr report based on itemno is wrong.
When i adapt the SQL load statement to say "... where ITEMNO = '850', only 1 item is loaded and displayed as "850", when it says "... where ITEMNO = '00850' also only 1 item is loaded en now displayed as "00850" (correct)
How can I make QlikView load my items correctly, that is, without chaging the value of any field?