2 Replies Latest reply: Aug 21, 2013 3:28 PM by Richard DeRocco RSS

    Alpha Content Converts to Numeric

      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 AS400As Represented
        in QlikView
      100000001
      0000000100000001

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

       

      Rich