<rowsource-filter>

Compares field values against column values in a rowsource.

field

Required: A reference to a field in the data file such as field="${part}", or an expression such as field="${part}:${location}".

rowsource

Required: Case-sensitive name of the rowsource.

column

Required: Case-sensitive name of the rowsource column against which the field values are matched.

match

If match="true", only records whose field values match the column values are let through to the <load> element. If match="false", only records whose field values do not match the column values are let through. (Default=true)

nolog

If nolog="false", records that do not match are logged as errors. If nolog="true", non-matches are not logged as errors. (Default:=false)

The following example includes only those data records where the part:location value matches a value in the component column of the Parts rowsource. Non-matching records are logged as errors.

<stage-rowsource rowsource="CMData">
   <rowsource-filter field="${part}:${location}"
   rowsource="Parts"
   column="component"/>
   ...
</stage-rowsource>