Hitachi Vantara Pentaho Community Wiki
Skip to end of metadata
Go to start of metadata

Sample rows

This step samples rows based on individual row numbers.  You can specify (one or more) individual row numbers or ranges.

Options

  • The name of the transformation, unique in a transformation
  • The lines range: the range or ranges or row numbers.  You can separate the ranges or individual row numbers with commas.  Ranges are specified with two decimals between the row numbers, for example: 5..10
  • Line nr fieldname: the name of the field that will contain the line number prior to sampling in the output.

Example

The following images shows a transformation that samples rows 1, 3 to and including 7 and 10 to and including 12.
You can find this example in your Kettle distribution package:

samples/transformations/Sample rows - basic example.ktr
  • No labels