There is a new KNIME forum. You can still browse and read content from our old forum but if you want to create new posts or join ongoing discussions, please visit our new KNIME forum: https://forum.knime.com

knime adding value to decimal

Member for

2 years 6 months gsakai

Hi guys,

Something really weird happened on knime.

 i have a excel reader node and there is a value for example 333333.33333333330, but something on knime adds the number five at the end changing to 333333.33333333335.

I am inserting this value on MySQL using Decimal(30,10) and the value get round up to 333333.3333333334 because of the value added by knime

would you know if this is a bug?

Thank you,

Gabriel

Comments
Fri, 02/23/2018 - 08:54

Member for

2 years 8 months

Jeany

Hi Gabriel,

Could you maybe attach a sample workflow where this happens? I am trying to reproduce the behaviour. Thank you!

Best,

Jeany

Fri, 03/02/2018 - 08:53

Member for

2 years 6 months

gsakai

Hi Jeany,

sorry, it took me so long to respond.

I am trying to reproduce the behavior, but the only thing that i noticed about this error, is that the node "Excel Reader" sometimes returns a extra number after the tenth number of the decimal point.

I will try to build a test that reproduce this behavior and i will postit.

Thank you for the return.

Best regards,
Gabriel Sakai