Sample rows

Sample rows

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


  • 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.


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