Leading zero missing

[qliktech_uk]

Hi

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 · Accepted solution]

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]

Thanks Anand.