Alpha Content Converts to Numeric

[#1]

Hi All,

I'm encountering an issue during a load from an AS/400. The data type in the AS/400 for a Ship-to code is Alpha in many cases those codes can be numeric values however when loaded to QlikView I'm getting strange results. See chart below:
              

As  Represented in the AS400	As Represented   in QlikView
1	00000001
00000001	00000001

Any ideas on how to suppress this conversion and retain the original data representation?

Rich

[swuehl · Accepted solution]

Try a text(FIELD), like in

LOAD

     text(FIELD) as FIELD,

     ...

[#3]

Thank you.