I have a couple tables of parts that I'm trying to compare (which parts are on which list or both, missing data on one table that is populated in another, etc). In doing so, I came across something disconcerting with Qlikview. Try the following script in a text box:
This should return 0 as the part numbers are different ('E' <> 'D'), but returns 1 instead. This also occurs if I use a "Group by PartID" statement in load statements, matching the 2 different IDs as the same, and even going so far as to tell me "9108DO3,9108DO3" for the result of
concat(PartID,',') as AllPartIDs
as my aggregate statement in the load script.
Hopefully I'm doing something wrong, but is there a way to make these two values not match?
Text fields with values like 1E4 or 1D4 could be misinterpreted. When loading text fields QlikView has always tried to interpret numeric values and load them as numeric, not text. Due to two different bugs the behaviour of QlikViews interpretation of exponential numbers, nnnEn or nnnDn, has changed between releases. The safest way to make sure you get the interpretation you like has always been to cast the specific fields to the right type in the script.