When you create a relationship between Orders and Returns on Order ID and build a view that uses fields only from the Orders table, what happens when Tableau sends the query to the database?
Tableau performs an inner join between Orders and Returns, returning rows present in both tables.
Tableau materializes a temporary combined table containing both Orders and Returns before querying.
Tableau automatically issues a left join from Orders to Returns to preserve all Orders rows.
Tableau queries only the Orders table; no join to Returns is generated.
Because relationships defer physical joins until they are required, Tableau will query only the tables that contribute fields to the view. Since the visualization contains fields exclusively from Orders, Tableau sends a single-table query to Orders and does not join to Returns. A join (inner, left, or otherwise) would be generated only after a field from Returns is added to the view. Tableau never materializes a combined table when using relationships-data remains in the original tables until queried.
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 are relationships in Tableau?
Open an interactive chat with Bash
How does Tableau decide which tables to query in a dataset with relationships?
Open an interactive chat with Bash
What happens if you add fields from both Orders and Returns in a view?
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 .