Data blending is when you blend data from more than one data source on a single worksheet within a workbook using Tableau Desktop. The data is joined on common dimensions. Data blending should be used when you have related data in multiple data sources that you want to analyze together in a single view.
Note: Tableau Desktop is required to blend multiple data sources.
The Creation Trends Worksheet is a good example of data blending from multiple data sources. Creation Trends worksheet uses a common dimension called Creation Date to link tables together from five (5) different data sources.
- Data blending requires a primary data source and at least one secondary data source. When you designate a primary data source, it functions as the main table or main data source. Any subsequent data sources that you use on the sheet are treated as a secondary data source. Only columns from the secondary data source that have corresponding matches in the primary data source appear in the view.
- If the date field in the primary and secondary data sources have the same name, Tableau creates the relationship between the two fields and shows a link icon () next to the date field in the secondary data source when the field is in the view.
The WIP by User Worksheet uses two (2) data sources joining on Card Type Title.
Doc ID: 1191981383