Working on Zero value

[Vijesh]

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.

[Somasundaram]

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.

[Vijesh]

Can you please explain with a qvw?

[Gabriel]

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]

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