0 Replies Latest reply: Dec 27, 2012 2:29 PM by Lisa Schroeder RSS

    Defining field from Access database as text

      One of my QlikView applications pulls data from an Access Database.  Access has a field as a text field, but when the data goes to QlikView it seems to convert some of the codes to numbers while leaving the ones beginning with a letter as text.  What can I do so that QlikView considers all entries for this field as text?  I tried modifying my load statement the way I’d do it if this was an Excel file.

      Text(Header_Diagnosis_Code_Primary) as [Primary Diagnosis Code]

      However, QlikView didn’t recognize the Text command as part of this load statement like it did in the load statements for my Excel files.

       

      Any help will be appreciated!