Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
m-wise
Partner - Contributor III
Partner - Contributor III

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

0 Replies