In the physical layer (Join/Union canvas) of a data model, you drag the Orders_2021 table directly beneath Orders_2020 until Tableau displays the prompt "Drag table to union." What type of connection will Tableau create between the two tables?
A data blend between two separate data sources
A union that stacks the rows from both tables
An inner join that returns only matching rows
A relationship that postpones joins until query time
Dragging one table directly below another in the physical layer until the prompt "Drag table to union" appears tells Tableau to create a union, not a join or relationship. A union appends the rows of the two tables; columns must match by name or will contain nulls when they don't. Joins, shown with a Venn-diagram icon when you drag tables side-by-side, combine rows horizontally on matching fields. Relationships are defined at the logical layer and defer joins until query time. Data blending links separate data sources in a worksheet and never occurs in the Data Source canvas. Therefore, Tableau creates a union in this scenario.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is the difference between a union and a join in Tableau?
Open an interactive chat with Bash
What happens if the column names in the tables being unioned do not match?
Open an interactive chat with Bash
How is a relationship different from a union or join in Tableau?
Open an interactive chat with Bash
Tableau Desktop Foundations
Connecting to and Preparing Data
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .