TDA-C01 Exam - Question 111

Question

A Data Analyst has a data source that has two tables named Table1 and Table2. Table1 is the primary table and Table2 is the secondary table.

The analyst wants to combine the tables by using Tableau Prep. The combined table must include only values from Table1 that do not match any values in Table2. The field values from Table2 must appear as null values.

Which type of join should the analyst use?

Examice · Accepted Answer

janasuresh · Answer

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.

Lakshmi2023 · Answer

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

ShazzyHawk · Answer

left only is correct

TDA-C01 Exam - Question 111

Discussion