While designing the logical layer of a Tableau data source, you need to combine a daily Sales table with a monthly Targets table on Customer ID and Month without duplicating rows or changing either table's level of detail. What should you do?
Union the two tables and use a calculated field to identify each record's source table.
Add the Targets table as a secondary data source and blend it to the primary Sales data by Customer ID.
Define a relationship between the Sales and Targets tables on Customer ID and Month in the logical layer.
Create an inner join on Customer ID and Month in the physical layer of the data source.
A relationship keeps each table at its native level of detail, only querying each table as needed, so it will not multiply rows when granularity differs. An inner join merges the tables physically and can duplicate rows if one table has more records for the same key. A union stacks rows vertically and is appropriate only when both tables share identical column structures. A data blend links separate data sources after a sheet is built and is unnecessary when both tables reside in the same data source and can be related directly.
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 logical layer in Tableau data sources?
Open an interactive chat with Bash
How does a relationship differ from an inner join in Tableau?
Open an interactive chat with Bash
When should you use a data blend instead of a relationship 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 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .