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