Subtract

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Subtract

Description

Remove rows from the top dataset with key values that are present in the lower dataset.

 

Inputs

2.

 

Options

The output depends on the vertical (Y-axis) position of the inputs.

Select Top key column for the column you want to match in the top input dataset.

Select Bottom key column for the column you want to match in the bottom input dataset.

 

Notes

If the first input has a header, this will be used for the output.

All values are treated as text and comparisons are case and whitespace sensitive. You can use Case to change the case and Trim to remove whitespace before the subtract.

Does not remove duplicates. You can use Dedupe to do this.

You can use Concat Cols to join several columns together (e.g. 'first name' and 'last name' columns) to form a key column.

 

See also

Intersect