How the data blending works in Tableau?
When you use data blending to combine data, a query is sent to the database for each data source that is used on the sheet. The results of the queries, including the aggregated data, are sent back to and combined by Tableau. The view uses all rows from the primary data source, the left table, and the aggregated rows from the secondary data source, the right table, based on the dimension of the linking fields.
Data Blending
1-when the dataset is from a different data source
2-Uses only left join.
3-Data can be available at different levels of granularity.
4-Sends separate queries to each dataset, aggregates, and then perform blending
Tableau Public Link:
https://public.tableau.com/app/profile/arabinda.mohapatra/viz/BLENDING_16509621767950/definitation?publish=yes
No comments:
Post a Comment