Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Reload bigint number from SQL database

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