0 Replies Latest reply: Dec 18, 2012 6:46 AM by R Winkel RSS

    Reload bigint number from SQL database

    R Winkel

      We have a document that reloads 300.000.000 records of data from a SQL database. In this table there is a field called MS_ID (Datatype BIGINT).

       

      When i try to reload the complete table something strange happens to the MS_ID. Qlikview changes the format of the number into some strange signs (see also the attachment).

       

      When i try to reload one subset of the table the field MS_ID looks correct, this issue only occurs when i reload the complete table. The MS_ID isn't longer than the maximum of 14 digits.

       

      Any ideas on how to fix this?

       

      Thanks for help