While viewing the logical layer on the Data Source page, you want to relate the Orders and Returns tables so Tableau controls aggregation and prevents row duplication. Which action should you take first to create this relationship?
Right-click Orders, choose Convert to Union, and then add Returns to the union.
Drag the Returns table onto the Orders table in the logical layer to open the Edit Relationship dialog.
Join Orders and Returns in the physical layer, setting the join type to Inner.
Select both tables in a worksheet and choose Data > Edit Relationships.
A relationship is created in the logical layer by positioning one logical table on top of, or next to, another. This drag-and-drop action opens the Edit Relationship dialog where matching fields, cardinality and referential integrity can be set. Converting to a union, editing blend relationships through the Data menu, or joining tables in the physical layer do not build a logical-layer relationship, so they will not provide the desired aggregation control.
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 the logical layer and the physical layer in Tableau?
Open an interactive chat with Bash
What is the purpose of cardinality and referential integrity in a relationship?
Open an interactive chat with Bash
How does Tableau handle aggregation in relationships compared to joins?
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 .