Why Qlikview changing my data during load?

[#1]

We have found a strange situation how QV manages loaded data. We have the following data in our system (in SQL server DB):

Entity ID (varchar(10)), Entity Name, ...

00149, Some name, ...

000149, Another name, ...

After data load we will see that "Some name" and "Another name" will have exatly the same key "000149". This is not correct and leads to amounts duplication.

I was able to reproduce this issue with inline data loading - see attached screenshots.

Why Qlikview changes original data during load?

[teempi · Accepted solution]

Hi,

I think QlikView will interpret your values as numbers and assume "00149" and "000149" are the same. I think the first found format is then used for both. Try changing your load script like this:

Vendor:

LOAD

          Text([Vendor ID]) AS [Vendor ID],

          [Vendor Name]

INLINE [

          Vendor ID, Vendor Name

          "000234", Qliktech

          "000149", MS

          "00149", Oracle

];

-Teemu

[CELAMBARASAN]

Qlikview automatically interprets as numbers if it is full of numbers unless we applied any function over it.

use text function to solve it.

Text(fieldName)

[#4]

Thanks a lot!