I'm not sure if I get your problem correctly, but I think that your problem is that qlikview evaluates your itemID as a number, and ommits the 0 therefore.
Does the attached file help you?
I loaded ItemID using the text() function, so the 041 and the 41 ItemID's are loaded "as is"
mergeProblem.qvw 147.0 K
Attached now my sample, how it looks like.
Somehow he dont "get" the ITEMIDs properly but merges them. 416 8 is an Item that is beeing merged into 041 68...
Anyone? Some more ideas? I am desperate...
Sample.qvw 1.1 MB
So the Podloska-Din..... and the VIJAK-PANHD should be separated (one belongs to the 04168 and the other to the 4168, right??)
In your load script, I don't see you use the text() function...
Additionally, I think you shouln't use resident load in this case...
So what if you change your loadscript to the script below (replace it after the odbc connect)
text(ITEMID),//to get the text representation instead of the numeric representation
SQL SELECT "DIMENSION10_",
I think your problem is that FIRST you load things in SQL (where the conversion to numeric is done already...) and THEN you do a resident load...
I think it is solved when you just load it (without resident) and load it as text instead of numeric
Let me know if it helped.