There's another query reference to my previous question.
I have a QVD Where I need to load as below:
MVKE: LOAD Text(MATNR) as Material, Text(MATNR) & VKORG AS MRP_Key FROM $(v_MasterQVDPath)\MVKE.QVD(qvd) where match(VKORG,'A001','F001') and match(VTWEG,'99') and Len(Trim(KONDM))>0 and Text(MATNR) = '0023128';
I have 2 Rows where MATNR = 0023128 & MATNR = 023128.
But, when we have a where condition as Text(MATNR) = '0023128' it returns 0 rows & when we have a where condition as Text(MATNR) = '023128' the load statement returns only 2 rows, but returns same values for both.
The original result is due to the way that QlikView tokenises the data as it is loaded. QlikView stores all data as dual data types. For text data the numeric part is blank.
When loading your data, the first value encountered is 00222, so QlikView will store the text value as 00222 and the token for the numeric equivalent 222.
When the second value is loaded 0222, QlikView recognises that the equivalent numeric value 222 already exists, so only stores a pointer to the existing value.
This is why you get the same value returned for rows 1 and row 2. Numeric data will store the first value encountered for that number as the text portion of the dual data.
To prevent this use the text() function which forces QlikView to treat the data in the field as text, so the values 00222 and 0222 are recorded as separate values.
