Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How are you doing the load? I've seen questions about QlikView automatically removing leading zeroes, but never heard of it adding them.
Try:
Load text(FIELD) As FIELD
Here's a recent thread on using text to retain leading zeroes: http://community.qlik.com/forums/t/18052.aspx
How are you doing the load? I've seen questions about QlikView automatically removing leading zeroes, but never heard of it adding them.
Try:
Load text(FIELD) As FIELD
Here's a recent thread on using text to retain leading zeroes: http://community.qlik.com/forums/t/18052.aspx
Hi,
I'd agreed with that - I had the problem of leading zeros vanishing but never them appearing! Definitely try the text(FIELD) AS FIELD option. That's worked for me. Word to the wise though - not sure if this will affect you. If you then want to export to Excel any with leading zeros will retain the text format but just numeric values probably won't. Not sure if this bug has been fixed in V9 (I'm currently with V8.5).
Cheers,
Emma
Thank you you both. That works fine.
Perfect !!