Data Blending: combine multiple sources into one dataset with Tableau or Alteryx

If your shared dimension is Product ID, the join produces a new table with all the data from left-table and additional rows from the right-table. You can set up a blended data warehouse where data sources maintain their unique qualities (including level of detail) and business analysts run ad hoc queries without needing support from computer scientists. Unlike joins, blended data self-serve tools:

As an example, let’s look at a blended data query for data sources with different levels of detail.

Source: blog.panoply.io