Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qliktech_uk
New Contributor III

Leading zero missing

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.

Tags (1)
1 Solution

Accepted Solutions

Re: Leading zero missing

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

];

2 Replies

Re: Leading zero missing

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
New Contributor III

Re: Leading zero missing

Thanks Anand.

Community Browser