Qlik Sense is cutting off leading 0

[wanyunyang]

I have zipcodes like 04106 (US) and v3w (Canada). When I code:

sql

select zipcode

from table;

It's cutting off leading 0. For example, 04106 becomes 4106. How can I fix this problem?

I have tried num(zipcode), but it's going to remove zipcodes like v3w.

Thanks in advance!

[YoussefBelloum · Accepted solution]

Hi,

try this:

table:

load

text(zipcode) as zipcode;

sql

select zipcode

from table;

[CarlosAMonroy]

Hi Wanyun,

I guess you can handle the field as text, instead of num. That way you will have both values with no alterations.

Carlos M