Discussion Board for collaboration on QlikView Scripting.
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