Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
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.
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.
Can you please explain with a qvw?
Looking at the attached screenshot, it looks like leading zeros are different.
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.
LOAD Text(StrNum) as StrNumFROM[NumTest.xlsx](ooxml, embedded labels, table is Sheet1);