Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, Im trying to import data from a dbf file with the following text format: "000000"
But some values has less than six characters (for example "0040")
When qlikview import this field, fills with zeros to complete the six characters format and bring "000040".
Is there a way to keep the original format?
have you tried using function text():
load
text(myField) as myTextField,
...
If you specify a format string "00000", you are asking QlikView to make all strings 6-characters long... Text() should do the trick for you.
Oleg
Thanks for your answer.
I've tried the text( ) function and it works just fine.!
Greetings