Exam TDA-C01 topic 1 question 180 discussion

This specific requirement (values only from the primary table that have no match in the secondary table, with secondary table fields showing as null) is precisely what a Left Only Join achieves. Let's break down why: A. Left Only: This join type (sometimes called an anti-join or Left Exclusive Join) returns only the rows from the left table (Table1) that do not have a matching row in the right table (Table2). For the fields originating from Table2, since there's no match, they will naturally appear as NULL. This perfectly fits the described requirement. B. Left: A standard Left Join returns all rows from the left table (Table1) and the matching rows from the right table (Table2). If there's no match in Table2 for a row in Table1, the fields from Table2 will be NULL. However, it also includes the rows where there is a match, which the requirement explicitly excludes ("only values from Table1 that do not match").

https://help.tableau.com/current/prep/en-us/prep_combine.htm

left only is correct

left Only : For each row, includes only values from the left table that don't match any values from the right table. Field values from the right table show as null values in the join results.

The join type should be "Left". There is nothing called "Left only" join.