topic Re: Store to csv, huge number is rounding up in App Development

Store to csv, huge number is rounding up

thi_pham — Wed, 08 Jan 2020 09:31:38 GMT

When I store a table with with huge numbers (>= 100B) to CSV file, it found they're formatted them like: 1.05E+11

Then, when I reload csv to qlik, number now is rounding up and lost the accuracy.

Is there anyway to get over it?

Thanks

Anil_Babu_Samineni — Wed, 08 Jan 2020 10:18:28 GMT

Qlik will provide up to 15 digits with exact match rows. Can you let us know how many digits are present when you talk about 100 Bytes?

Perhaps use Text() over field like

Text(FieldName) as FieldName

thi_pham — Wed, 08 Jan 2020 10:50:34 GMT

Hello @Anil_Babu_Samineni , 100B I mean 100 Billions -> 12 digits. Sorry for making you confused.

when using text(Field) when storing file, do we need to convert it again to number when load?

Just found, 100 Billions will not cause the issue, but the negative 100 Billions did.