What it does: Removes rows from the first table that don’t exist in the second table based on a specified column.
How to use it: Choose the column from each table to use to find matching values.
- Case: Switch on to be case sensitive in the attempted matching.
- Does Not Contain: Switch on to only pass the rows which are NOT found in the second table instead.
- Fuzzy: Attempt to perform “fuzzy” matching, rather than exact matching. This will match misspelled words or company names in different formats.
Did this answer your question?