topic Reload bigint number from SQL database in QlikView https://community.qlik.com/t5/QlikView/Reload-bigint-number-from-SQL-database/m-p/446601#M698875 <HTML><HEAD></HEAD><BODY><P>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). </P><P></P><P>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).</P><P></P><P>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.</P><P></P><P>Any ideas on how to fix this?</P><P></P><P>Thanks for help</P></BODY></HTML> Tue, 18 Dec 2012 11:46:02 GMT m-wise 2012-12-18T11:46:02Z Reload bigint number from SQL database https://community.qlik.com/t5/QlikView/Reload-bigint-number-from-SQL-database/m-p/446601#M698875 <HTML><HEAD></HEAD><BODY><P>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). </P><P></P><P>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).</P><P></P><P>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.</P><P></P><P>Any ideas on how to fix this?</P><P></P><P>Thanks for help</P></BODY></HTML> Tue, 18 Dec 2012 11:46:02 GMT https://community.qlik.com/t5/QlikView/Reload-bigint-number-from-SQL-database/m-p/446601#M698875 m-wise 2012-12-18T11:46:02Z