topic Problems reading strings from dbf file in QlikView

Problems reading strings from dbf file

Thu, 23 Apr 2009 23:20:53 GMT

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?

Oleg_Troyansky — Thu, 23 Apr 2009 23:32:04 GMT

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

Thu, 30 Apr 2009 05:12:02 GMT

Thanks for your answer.

I've tried the text( ) function and it works just fine.!

Greetings