Qlik Sense has a problem storing data when there leading zeroes

[#1]

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?

[sunny_talwar]

Try may be this:

Num(upc) as upc

or

upc * 1 as upc

[swuehl · Accepted solution]

Try to load your values as text

LOAD

     Text(upc) as upc,

[dionverbeke]

or try set verbatim = 1