topic Re: Working on Zero value in App Development

Working on Zero value

Vijesh — Tue, 22 Jan 2019 12:10:29 GMT

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,

Re: Working on Zero value

Somasundaram — Tue, 22 Jan 2019 12:17:20 GMT

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.

Re: Working on Zero value

Vijesh — Tue, 22 Jan 2019 12:18:31 GMT

Can you please explain with a qvw?

Re: Working on Zero value

Gabriel — Tue, 22 Jan 2019 12:41:11 GMT

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.

Re: Working on Zero value

vvira1316 — Tue, 22 Jan 2019 13:50:09 GMT

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