Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Vijesh
Contributor
Contributor

Working on Zero value

Hello,

I am facing an issue regarding a value/number starting with zeros.

I have a field named product Code, which have code numbers in numeric value which begins with zeros.

For example:

0000001

000001

while extracting to QlikView, both numbers will be store in same number (i.e. 0000001)

Product code has only unique value. in this stage after extracting I am getting duplicate values.

Please help.

 

Thanks,

V.

 

4 Replies
Somasundaram
Creator III
Creator III

HI,

IF you you are extracting as a number, it will show based on the number format.

You can try with Text( Field_Name) while extracting data from DB source.

 

 

 

 


-Somasundaram

If this resolves your Query please like and accept this as an answer.
Vijesh
Contributor
Contributor
Author

Can you please explain with a qvw?

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

Looking at the attached screenshot, it looks like leading zeros are different.

Points observed:

1- One product code has 6 leading zeros while the second has 5 leading zeros. To resolve this, your dba can update the product code or ask why product code leading zeros are different.

2- The Product is different so this will cause the duplicate, as in A & B.

You can attached data file, i.e. excel for further investigation.

vvira1316
Specialist II
Specialist II


LOAD Text(StrNum) as StrNum
FROM
[NumTest.xlsx]
(ooxml, embedded labels, table is Sheet1);

 

 

num.PNG       num.PNG