Cross-database joins in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a cross-database join between two tables.

Tableau

JOINED_DATA = TABLE1 [1] TABLE2 ON TABLE1.ID = TABLE2.ID

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

ARIGHT JOIN

BINNER JOIN

CLEFT JOIN

DFULL JOIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using LEFT JOIN when only matching rows are needed.

Forgetting to specify the join condition.

Use INNER JOIN to combine rows from both tables where the IDs match.

2fill in blank

medium

Complete the code to specify the data source for a cross-database join in Tableau.

Tableau

JOINED_DATA = [1].TABLE1 INNER JOIN DATABASE2.TABLE2 ON TABLE1.ID = TABLE2.ID

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

ALOCAL

BTABLEAU

CSERVER1

DDATABASE1

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong database name or a generic term.

Omitting the database name causing ambiguity.

Specify the first database name before the table to join across databases.

3fill in blank

hard

Fix the error in the cross-database join syntax.

Tableau

SELECT * FROM DATABASE1.TABLE1 [1] DATABASE2.TABLE2 ON TABLE1.ID = TABLE2.ID

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

AINNER JOIN

BLEFT JOIN

CJOIN

DCROSS JOIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using JOIN without INNER causing syntax errors.

Using CROSS JOIN which ignores ON condition.

Use INNER JOIN with an ON clause to join tables properly.

4fill in blank

hard

Fill both blanks to complete the Tableau cross-database join expression.

Tableau

JOINED_DATA = [1].TABLE1 [2] DATABASE2.TABLE2 ON TABLE1.KEY = TABLE2.KEY

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

ADATABASE1

BLEFT JOIN

CINNER JOIN

DRIGHT JOIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong join type that doesn't match the requirement.

Omitting the database name causing ambiguity.

Specify the first database and use INNER JOIN to combine matching rows.

5fill in blank

hard

Fill all three blanks to write a correct cross-database join in Tableau.

Tableau

SELECT [1] FROM [2].TABLE1 [3] DATABASE2.TABLE2 ON TABLE1.ID = TABLE2.ID

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

A*

BDATABASE1

CINNER JOIN

DTABLE1.ID

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting a specific column instead of all columns.

Using wrong join type causing incorrect results.

Omitting database name causing ambiguity.

Select all columns with '*', specify the first database, and use INNER JOIN for matching rows.