Sample rows
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