Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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)
Thanks a lot!