JAVA Pipelines

Drop records
Filter:: DROP
Syntax:: DROP [end] Nrecords
Operands:: Nrecords :: integer > 0 | *
end :: FIRST (default) | LAST
Functional Description:: Use the DROP stage to discard one or more records at the beginning or end of its primary input stream. DROP selects the remaining records, copying them to its primary output stream, if it is connected. If its secondary output stream is connected, DROP passes any unselected records to its secondary output stream.

FIRST discards records from the beginning of the input stream. This is the default.

LAST selects records until only the specified number remain, and discards the last specified number of records from the end of the input stream.

n is the number of records to discard from the input stream. The default is 1. If you specify 0 for n, all records in the primary input stream are selected and copied unchanged to the primary output stream.

* specifies that no records are selected. These are passed to the secondary output stream if it is connected, otherwise, DROP discards all records.
Secondary Input/Output:: OUTPUTs
Synonyms:: none
Usage Notes:: The following example will drop the first 10 records.

| DROP first 10 |

The following example will drop the last 7 records.

| DROP last 7 |

JAVA Pipelines