Qlik is eliminating different string with almost same chars

[sagarjagga]

Hi All,

In data base i have 2 codes - 501 and 501.00000 but when loading this code through SQL select in qlik , qlik is returning only 501.00000(it is eliminating 501).

can you please help me with that

[marcus_sommer · Accepted solution]

You need to enforce a string-interpretation of this field, for example with:

load text(code) as code;
sql select code from source;

- Marcus