Complex Data Blends – Blending across multiple fields.


Complex Data Blends – Blending across multiple fields.


In a perfect world, we’d have a single comprehensive data source to meet all our analytical needs. When that can’t happen, I frequently turn to Tableau’s Data Blending functionality that allows me to access and combine data stored in multiple systems.

Data blending is a fantastic resource for situations where I have been working with a single data source and need to blend in information from outside my original source. One common scenario is comparing actual sales reporting data with budget/planned sales numbers that live outside the data warehouse. Tableau 7 has been built to analyze the data sources and automate blending when possible. Occasionally, though, my blends need to be more complex and span multiple fields.

Join me for a quick video walkthrough of blending together two data sources using a complex blend across multiple fields. Feel free to download the attached Packaged Workbook and see for yourself how powerful this technique can be with the proper application.

More About the Author

James Wright

Global BI Practice Director
Unexpected Surprises: IMDB Movie Analytics I haven’t blogged much recently, but I wanted to quickly share a really great moment. Onsite with one of our long-term and larger NYC ...
10 Ways to Drive End-User Adoption of Tableau – Part 2 Ready to pick up where we left off? Last week, I posted “10 Ways to Drive End-User Adoption of Tableau – Part 1.” ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK


Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Geschäftsführer: Mel Stephenson

Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072