Chapter 2

formatting data

1

(a) and (b). The field is already a Number, so you may define the output field as a Number, taking care of the format you apply. If you define the output field as a String and you don't set a format, Kettle will send the field to the output as 1.0, 2.0, 3.0, etc., which clearly is not the same as your code. Just to confirm this, create a single file and a transformation to see the results for yourself.

Get Pentaho 3.2 Data Integration Beginner's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.