Chapter 4, Filtering, Searching, and Performing Other Useful Operations with Data

Pop quiz – formatting output fields

Q1

Possible answers are 1 and 2. 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 0.0, 1.0, 2.0, 3.0, and so on, which clearly is not the same as the input you had. Just to confirm this, modify the transformation to see the results for yourself.

Get Pentaho Data Integration Beginner's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.