strange data misinterpretation

[mikevmalta]

Hi,

I have the following scenario:

I am reading codes from the database, where each code consists of numbers and letters. However there are some codes where the letter 'E' is being converted to the letter 'D'. Example:

Temp:

LOAD * INLINE

[

CUSTOMERID, CUSTOMERSTATUS, ADDRESS,                     CODE,

4879,                    Active,                    0030545578D3,                    84,

552829,                    Active,                    0030545578E3,                    35,

];

If you see the data in a table, you will find that both codes are interpreted to '0030545578D3'.

Do you know why this is happening?

Thanks in advance!

[swuehl]

Sorry, I can't reproduce your issue using the above INLINE table. On which QV version are you?

[mikevmalta]

Hi,

Thanks for your reply.

I am using Qlikview 11. Please find attached my test .qvw.

Thanks

Michael

[swuehl · Accepted solution]

Testing also on QV11, after reloading your app, the code changes to the correct value.

I noticed that your field is tagged with numeric, integer, while my field is tagged as text, so probably QV automatic number interpretation in your version plays a role here.

Just an idea, try

Temp:

LOAD CUSTOMERID, CUSTOMERSTATUS, text(ADDRESS) as ADRESS, CODE INLINE

[

CUSTOMERID, CUSTOMERSTATUS, ADDRESS,         CODE,

4879,        Active,        0030545578D3,        84,

552829,        Active,        0030545578E3,        35,

];

[mikevmalta]

Thanks a lot swuehl!

That did the trick