Search code examples
pentahokettle

Pentaho cuts double values from Table Input

I have a Problem that I could not fix up to now. When I do a "Select" at a Table-Input the double values are not returned completely and are always cut. Here are some examples: 15.0420 => 15 // 12.6000 => 12,6 // 4.1176 => 4,1 // 0.1123 => 0,1 // 0.0012 => 0

I seems like, that minimum two numbers are shown and max one number after the comma. However it is very important to get the right figures. I use pentaho 6.1, and mariaDB 5.5.49.

Thanks for every help.

Best regards, Dave

Solution

  • Finally I adjusted the configuration of the Default Number Format. Under "Edit->Edit the kettle.properties file", I set the "KETTLE_DEFAULT_NUMBER_FORMAT" with the format '#.####'. Now it is working!