Hitachi Vantara Pentaho Community Wiki

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

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:

Code Block
samples/transformations/Sample rows - basic example.ktr