Error loading data

[munirche]

Hello,

I am having trouble with qlikview when loading a very specific set of data. For some strange reason, QV does not recognize "0E0" and "0E1" as different data values. When loading the following table, qv reads 5 records but only 4 distinct values.

this is the script:

T_Table:
LOAD * INLINE [
Field
0E1
0E0
AAA
BBB
CCC];

I would appreciate if anyone knows how to fix this.

Regards,

munirche

[#2 · Accepted solution]

That is weird. I can't say I know why it is happening.

To fix it, you should format the field as Text, use:

T_Table:
LOAD Text(Field) As Field INLINE [
 Field
 0E1
 0E0
 AAA
 BBB
 CCC
];

EDIT: Could QlikView be treating it as scientific notation? 0 x 10^1 and 0 x 10^0 would both be zero?

[pover]

Your observation looks correct since =1E0*5 in QlikView equals 5 and QlikView treats 0A1 and 0A0 as distinct.

[munirche]

NMiller, thanks for your help.

Regards,

munirche