Union and join basics in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a union of two tables named Sales2023 and Sales2024.

Tableau

UNION([1], Sales2024)

Drag options to blanks, or click blank then click option'

ASales2023

BJOIN

CMERGE

DAPPEND

Attempts:

3 left

💡 Hint

Common Mistakes

Using JOIN instead of UNION

Using MERGE which is not a Tableau function

Using APPEND which is not a Tableau function

The UNION function combines rows from two tables. Here, Sales2023 is the first table to union with Sales2024.

2fill in blank

medium

Complete the code to join Customers and Orders tables on CustomerID.

Tableau

JOIN Customers ON Customers.CustomerID = [1].CustomerID

Drag options to blanks, or click blank then click option'

AOrders

BEmployees

CProducts

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Joining Customers with Sales instead of Orders

Using Products or Employees tables incorrectly

The JOIN is between Customers and Orders tables using the CustomerID field from Orders.

3fill in blank

hard

Fix the error in the join condition to correctly join Products and Categories on CategoryID.

Tableau

JOIN Products ON Products.CategoryID = [1].CategoryID

Drag options to blanks, or click blank then click option'

ACustomers

BSales

COrders

DCategories

Attempts:

3 left

💡 Hint

Common Mistakes

Using Sales or Orders instead of Categories

Joining on wrong fields

The join should be between Products and Categories tables on the CategoryID field.

4fill in blank

hard

Fill both blanks to create a left join between Employees and Departments on DepartmentID.

Tableau

LEFT JOIN [1] ON Employees.DepartmentID = [2].DepartmentID

Drag options to blanks, or click blank then click option'

ADepartments

BEmployees

CProjects

DTasks

Attempts:

3 left

💡 Hint

Common Mistakes

Using Employees or other tables instead of Departments

Mixing table names in join condition

We join Employees with Departments on DepartmentID. Both blanks refer to Departments table.

5fill in blank

hard

Fill all three blanks to create an inner join between Orders and Customers on CustomerID and select CustomerName.

Tableau

SELECT [1] FROM Orders JOIN [2] ON Orders.CustomerID = [3].CustomerID

Drag options to blanks, or click blank then click option'

ACustomerName

BCustomers

DOrderDate

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting wrong fields like OrderDate

Joining with wrong tables

Using inconsistent table aliases

The SELECT clause chooses CustomerName. The join is between Orders and Customers on CustomerID.