{"id":3386,"date":"2024-05-05T23:13:02","date_gmt":"2024-05-05T21:13:02","guid":{"rendered":"https:\/\/newdatalabs.com\/en\/?p=3386"},"modified":"2024-05-05T23:13:04","modified_gmt":"2024-05-05T21:13:04","slug":"data-blending-in-tableau","status":"publish","type":"post","link":"https:\/\/newdatalabs.com\/en\/data-blending-in-tableau\/","title":{"rendered":"Data Blending in Tableau"},"content":{"rendered":"\n

Do you work with Explorer and want to combine your data? Or perhaps you have a license for Creator, but your ability to link the data is limited due to data security policies? If yes, you should definitely find out more about Data Blending.<\/strong><\/p>\n\n\n\n

How to combine data in Tableau?<\/h2>\n\n\n\n

Everyone, who works with Tableau, is aware that sometimes a single table with data is not sufficient and you need to extract additional information from another table. There are several ways to do that. You can ask you data engineer to perform it in SQL, however it is best to do it by yourself. If you have a license for Creator, you have the following three options: joins, relationships and blending. Joins allow you to combine data into one large table. Relationships present tables separately, but they define the way to quickly join the data when needed. Then Tableau will automatically create relevant joins. The last option is blending. The simplest definition would be to say it is the aggregated left join \u201con the fly.\u201d But what does it mean and when to use it?<\/p>\n\n\n\n

The story behind blending<\/h2>\n\n\n\n

In the past, data blending in Tableau played a significant role as it helped join the data from various databases. Later on, the function Cross Data Join was introduced, which allows us to combine the data by joins, and it took over this capability from blending almost completely. However, blending still helps combine the data at various levels of detail, but these days, it is being pushed out by relationships. When should you use it then?<\/p>\n\n\n\n

First of all, it\u2019s suitable for users, who have a license for Explorer. They can create reports only based on ready data sources stored in Tableau Online (Cloud) or Tableau Server. They don\u2019t have access to joins and relationships, but they can use blending.<\/p>\n\n\n\n

However, if you have a Creator license, you can work on the source protected in the Row Level Security. Adding a table to your source to configurate the security on the row level makes it almost impossible to use relationships. There is no problem with joins, however they aren\u2019t good when you have data sources with various levels of detail. Blending would be a better choice here.<\/p>\n\n\n\n

How does blending work?<\/h2>\n\n\n\n

I have already quoted my favourite definition, which says \u201cblending is the aggregated left join on the fly.\u201d What does it mean? The best approach is to explain it step by step. Let\u2019s start with the left join. It is a method allowing to combine two tables in one summary table. In order to do that, start with identifying the key field. This is a column with the dimension that is common for two tables. In the below example, this will be a Segment. Sometimes you may have several common fields and the left join allows you to add to all the rows in the left table (the first table) the rows from the second table, which have the values of the key field in the first table. Where there is no data to be combined, cells are left blank (nulls), as illustrated in the drawing below. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

The Left Join is additionally aggregated in blending. This means a different approach in the situation where in the table on the right you have several rows which correspond with the row on the left. In the case of a join, all of these rows will be added to the summary table, each of them separately. In blending, the values from the table on the right-hand side will be aggregated and further processed in the aggregated form. This aggregation is usually the sum as illustrated below. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

It is the aggregation that makes blending useful when you have various levels of data since it prevents unnecessary duplication of rows.<\/p>\n\n\n\n

Last but not least, the term \u201con the fly.\u201d Blending works the same way as the left join, the only difference is that the left join permanently links the tables. It is an integral part of preparing the source of data, whereas blending is built at the level of one specific visualization and will work in this particular visualization only.<\/p>\n\n\n\n

Drawbacks of blending<\/p>\n\n\n\n

It is not without a reason that blending has been gradually replaced by other solutions. Also many Tableau users don\u2019t like it for a reason as it has certain drawbacks. The most significant disadvantage is that it doesn\u2019t work for non-additive aggregations. We can sum up \u2013 calculate the average. However, you won\u2019t be able to count unique items \u2013 COUNTD, or medians. Another issue are all number functions except for MIN() and MAX(). Therefore, you may not be able to calculate roots, cosines on the blended data, or to round them off. In addition, it\u2019s also difficult to calculate LODs based on blending, so these solutions seem to be designed for simpler tasks, but sometimes there is no other choice.<\/p>\n\n\n\n

Agata M\u0119\u017cy\u0144ska<\/p>\n\n\n\n

Tableau Desktop Certified Professional<\/p>\n","protected":false},"excerpt":{"rendered":"

Do you work with Explorer and want to combine your data? Or perhaps you have a license for Creator, but your ability to link the data is limited due to data security policies? If yes, you should definitely find out more about Data Blending. How to combine data in Tableau? Everyone, who works with Tableau, […]<\/p>\n","protected":false},"author":1,"featured_media":3390,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"content-sidebar","footnotes":""},"categories":[9,5],"tags":[],"class_list":{"0":"post-3386","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-blog","8":"category-tableau","9":"entry"},"yoast_head":"\nData Blending in Tableau - NewDataLabs<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/newdatalabs.com\/en\/data-blending-in-tableau\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Blending in Tableau - NewDataLabs\" \/>\n<meta property=\"og:description\" content=\"Do you work with Explorer and want to combine your data? Or perhaps you have a license for Creator, but your ability to link the data is limited due to data security policies? If yes, you should definitely find out more about Data Blending. How to combine data in Tableau? Everyone, who works with Tableau, […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/newdatalabs.com\/en\/data-blending-in-tableau\/\" \/>\n<meta property=\"og:site_name\" content=\"NewDataLabs\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-05T21:13:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-05T21:13:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/blog.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"360\" \/>\n\t<meta property=\"og:image:height\" content=\"216\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Barbara\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Barbara\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/data-blending-in-tableau\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/data-blending-in-tableau\\\/\"},\"author\":{\"name\":\"Barbara\",\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/#\\\/schema\\\/person\\\/dfa2df2f2fb6fcecdd8f69f00cffba29\"},\"headline\":\"Data Blending in Tableau\",\"datePublished\":\"2024-05-05T21:13:02+00:00\",\"dateModified\":\"2024-05-05T21:13:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/data-blending-in-tableau\\\/\"},\"wordCount\":837,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/data-blending-in-tableau\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/blog.jpg\",\"articleSection\":[\"Blog\",\"Tableau\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/newdatalabs.com\\\/en\\\/data-blending-in-tableau\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/data-blending-in-tableau\\\/\",\"url\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/data-blending-in-tableau\\\/\",\"name\":\"Data Blending in Tableau - NewDataLabs\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/data-blending-in-tableau\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/data-blending-in-tableau\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/blog.jpg\",\"datePublished\":\"2024-05-05T21:13:02+00:00\",\"dateModified\":\"2024-05-05T21:13:04+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/#\\\/schema\\\/person\\\/dfa2df2f2fb6fcecdd8f69f00cffba29\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/data-blending-in-tableau\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/newdatalabs.com\\\/en\\\/data-blending-in-tableau\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/data-blending-in-tableau\\\/#primaryimage\",\"url\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/blog.jpg\",\"contentUrl\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/blog.jpg\",\"width\":360,\"height\":216},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/data-blending-in-tableau\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Strona g\u0142\u00f3wna\",\"item\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Blending in Tableau\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/\",\"name\":\"NewDataLabs\",\"description\":\"Tableau - Business Intelligence Tools\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/newdatalabs.com\\\/en\\\/#\\\/schema\\\/person\\\/dfa2df2f2fb6fcecdd8f69f00cffba29\",\"name\":\"Barbara\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/8805976098f215eb8413b85141c17705f7ac9d91ccc0f83881d7eae1eab8c7f1?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/8805976098f215eb8413b85141c17705f7ac9d91ccc0f83881d7eae1eab8c7f1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/8805976098f215eb8413b85141c17705f7ac9d91ccc0f83881d7eae1eab8c7f1?s=96&d=mm&r=g\",\"caption\":\"Barbara\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Blending in Tableau - NewDataLabs","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/newdatalabs.com\/en\/data-blending-in-tableau\/","og_locale":"en_US","og_type":"article","og_title":"Data Blending in Tableau - NewDataLabs","og_description":"Do you work with Explorer and want to combine your data? Or perhaps you have a license for Creator, but your ability to link the data is limited due to data security policies? If yes, you should definitely find out more about Data Blending. How to combine data in Tableau? Everyone, who works with Tableau, […]","og_url":"https:\/\/newdatalabs.com\/en\/data-blending-in-tableau\/","og_site_name":"NewDataLabs","article_published_time":"2024-05-05T21:13:02+00:00","article_modified_time":"2024-05-05T21:13:04+00:00","og_image":[{"width":360,"height":216,"url":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/blog.jpg","type":"image\/jpeg"}],"author":"Barbara","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Barbara","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/newdatalabs.com\/en\/data-blending-in-tableau\/#article","isPartOf":{"@id":"https:\/\/newdatalabs.com\/en\/data-blending-in-tableau\/"},"author":{"name":"Barbara","@id":"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/dfa2df2f2fb6fcecdd8f69f00cffba29"},"headline":"Data Blending in Tableau","datePublished":"2024-05-05T21:13:02+00:00","dateModified":"2024-05-05T21:13:04+00:00","mainEntityOfPage":{"@id":"https:\/\/newdatalabs.com\/en\/data-blending-in-tableau\/"},"wordCount":837,"commentCount":0,"image":{"@id":"https:\/\/newdatalabs.com\/en\/data-blending-in-tableau\/#primaryimage"},"thumbnailUrl":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/blog.jpg","articleSection":["Blog","Tableau"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/newdatalabs.com\/en\/data-blending-in-tableau\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/newdatalabs.com\/en\/data-blending-in-tableau\/","url":"https:\/\/newdatalabs.com\/en\/data-blending-in-tableau\/","name":"Data Blending in Tableau - NewDataLabs","isPartOf":{"@id":"https:\/\/newdatalabs.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/newdatalabs.com\/en\/data-blending-in-tableau\/#primaryimage"},"image":{"@id":"https:\/\/newdatalabs.com\/en\/data-blending-in-tableau\/#primaryimage"},"thumbnailUrl":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/blog.jpg","datePublished":"2024-05-05T21:13:02+00:00","dateModified":"2024-05-05T21:13:04+00:00","author":{"@id":"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/dfa2df2f2fb6fcecdd8f69f00cffba29"},"breadcrumb":{"@id":"https:\/\/newdatalabs.com\/en\/data-blending-in-tableau\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/newdatalabs.com\/en\/data-blending-in-tableau\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/newdatalabs.com\/en\/data-blending-in-tableau\/#primaryimage","url":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/blog.jpg","contentUrl":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/05\/blog.jpg","width":360,"height":216},{"@type":"BreadcrumbList","@id":"https:\/\/newdatalabs.com\/en\/data-blending-in-tableau\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Strona g\u0142\u00f3wna","item":"https:\/\/newdatalabs.com\/en\/"},{"@type":"ListItem","position":2,"name":"Data Blending in Tableau"}]},{"@type":"WebSite","@id":"https:\/\/newdatalabs.com\/en\/#website","url":"https:\/\/newdatalabs.com\/en\/","name":"NewDataLabs","description":"Tableau - Business Intelligence Tools","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/newdatalabs.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/dfa2df2f2fb6fcecdd8f69f00cffba29","name":"Barbara","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/8805976098f215eb8413b85141c17705f7ac9d91ccc0f83881d7eae1eab8c7f1?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/8805976098f215eb8413b85141c17705f7ac9d91ccc0f83881d7eae1eab8c7f1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8805976098f215eb8413b85141c17705f7ac9d91ccc0f83881d7eae1eab8c7f1?s=96&d=mm&r=g","caption":"Barbara"}}]}},"_links":{"self":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts\/3386","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/comments?post=3386"}],"version-history":[{"count":1,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts\/3386\/revisions"}],"predecessor-version":[{"id":3391,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts\/3386\/revisions\/3391"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/media\/3390"}],"wp:attachment":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/media?parent=3386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/categories?post=3386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/tags?post=3386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}