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
Any ideas on how to suppress this conversion and retain the original data representation?