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

Browser not supported