Store to csv, huge number is rounding up

[thi_pham]

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]

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]

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.