Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik Community,
I notice that when the values of the UPC are identical except for for the leading zeroes, Qlik just grab the first value. In this example, the one highlighted in yellow is replaced with the one on top?
Please advise how I can fix this?
Try may be this:
Num(upc) as upc
or
upc * 1 as upc
Try to load your values as text
LOAD
Text(upc) as upc,
or try set verbatim = 1