Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I've an issue while reading data from an as400 file.
I'm doing a simply select statement like:
select <field> from table.
The field is a numeric field (13,2), and I assume it should be with 2 decimal numbers.
By the way if I Override the Document Settings and I set it fixed to 14 Decimals, strange numbers appears in the decimal position.
e.g.:
The correct number should be -73881.71, but with the 14 decimal visualization I get -73881.71000000000600
I'm damn sure that in AS400 the correct number is -73881.71
Can anybody give me a hint please ?
Thanks in advance
Alessio
If it's needed I can attach the qlik file (even if the connection will not work of course).
I've an Update, if anybody is interested:
if I load the data of a single Customer, the number is correct, without any additional decimal number.
If I load the data of billions of Customer, the number isn't correct anymore.
Hope somebody will help me.
Thanks