data display problem

[#1]

Hi,
I have a problem somewhat "strange" ...

I extract from the archive of articles AS400 : item code, description, family ...

The article is 15 alphanumeric code, where the first 2 characters from the left identify the family ...

In the example the article "140750 jacket" in truth is '0140750' like on AS

missing the first zero ... but it is true that the first zero is missing in all articles.

Surely, in view qlik data are mixed.

See example.

Someone could help me? is rather urgent.


Thank you very much

on AS:

Item Description Family
140750 SLIP GARDA 3945 14
0140750 OR GIUBBINO MELBY A47165 01

[#2 · Accepted solution]

Here is a previous thread on the subject: http://community.qlik.com/forums/t/18052.aspx.

In your load, use:

LOAD TEXT(fieldname) As fieldname

[#3]

thanks a lot ..

in truth I had never happen ... maybe because I always had alphanumeric Articles ...

thanks anyway