topic Re: Why Qlikview changing my data during load? in QlikView

Why Qlikview changing my data during load?

Fri, 02 Nov 2012 12:41:53 GMT

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?

Re: Why Qlikview changing my data during load?

teempi — Fri, 02 Nov 2012 12:48:06 GMT

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

Re: Why Qlikview changing my data during load?

CELAMBARASAN — Fri, 02 Nov 2012 12:54:54 GMT

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)

Re: Why Qlikview changing my data during load?

Fri, 02 Nov 2012 13:00:46 GMT

Thanks a lot!