topic Leading zero missing in QlikView

Leading zero missing

qliktech_uk — Wed, 27 Sep 2017 18:03:46 GMT

In my data field I have the leading 0 missing that I receive in excel and due to this I am unable to get the correct result.

eg:

012344444444 is represented as 12344444444.

How would I join this data?

Thanks.

its_anandrjs — Wed, 27 Sep 2017 18:10:24 GMT

Try this in your table where you need zvero use Num(Cola,'000000000000') as NewField

LOAD *,Num(Cola,'000000000000') as NewField;

LOAD * Inline

[

Cola

12344444444

];

qliktech_uk — Wed, 27 Sep 2017 18:19:33 GMT

Thanks Anand.