Last Modified Date: 20 Jun 2017
- Tableau Desktop
- Data blending when linking field contains more than 300,000 unique values
ResolutionCreate a single connection that includes all the columns from multiple tables by defining all joins between tables as part of the data connection.
CauseData blending is not a database join engine, but an in-memory method for visualizing data from different data sources. Using data blending as a substitute for database level joins will result in out of memory errors because Tableau Desktop is forced to do the computations rather than the underlying database.
Additional InformationData blending is best suited for post-aggregate queries instead of individual detail row joins. For example, data blending can be used to examine the sum of sales across time from one data source and blend it with sum of sales quotes across time from another data source. Data blending matches the resulting rows of the two queries together based on the values of time instead of joining the individual atomic data then doing aggregations on it.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials