You have a data source that has two tables named Table1 and Table2. Table1 is the primary table and Table2 is the secondary table. You want to…

To combine the tables by using Tableau Prep and include only values from Table1 that do not match

any values in Table2, you should use a left only join. A left only join is a type of join that returns only

the rows from the primary table (Table1) that have no matching rows in the secondary table (Table2).

The field values from Table2 will appear as null values in the combined table. A left only join is also

known as an anti-join or an exclusion join. Reference:

Tableau Certified Data Analyst Exam Prep Guide, page 9, section “Preparing Data”

Tableau Help: Join Your Data

Tableau Help: Left Only Join