The key(s) to look up the value(s) table

The columns in the following table define the key(s) used to map the row(s) to delete.

Column	Description
Table field	Specify the field name from the populated list of Target table columns for which you want to compare.
Comparator	Specify the comparator you want to use. Note that case-sensitive comparisons are possible, depending on your connected database and Target table.You can select one of the following comparators: = <> < <= > >= LIKE BETWEEN IS NULL IS NOT NULL
Stream field 1	Specify the name of the field from the incoming stream that contains the row you want to use for comparison against the Table field value.
Stream field 2	Specify the name of the field from the incoming stream that contains the row you want to use for the BETWEEN comparison against the Stream field 1.
Get fields	Select this button to populate Stream field 1 and Stream field 2 from previous steps in your transformation.

For example, if the look up value of `QUANTITYORDERED` is less than or equal to the `min_quantityordered`, and `PRODUCTLINE` values map equally, then that `QUANTITYORDERED` row is deleted from the `STG_SALES_DATA` table.