About Mismatched Values in Blended Data

In some cases when the rows of data that you expect to see in a data set are missing, then you must specify which data set to use for data blending.

Sometimes rows of data are missing when your project includes data from two data sets that contain a mixture of attributes and values, and there are match values in one source that don’t exist in the other.

Suppose we have two data sets (Source A and Source B) with slightly different rows, as shown in the following image. Note that Source A doesn‘t include IN-8 and Source B doesn’t include IN-7.



The following results are displayed if you select the All Rows data blending option for Source A and select the Matching Rows data blending option for Source B. Because IN-7 doesn’t exist in Source B, the results contain null Rep and null Bonus.



The following results are displayed if you select the Matching Rows data blending option for Source A and select the All Rows data blending option for Source B. Because IN-8 doesn’t exist in Source A, the results contain null Date and null Revenue.



The visualization for Source A includes Date as an attribute, and Source B includes Rep as an attribute, and the match column is Inv#. Under dimensional rules, you can’t use these attributes with a measure from the opposite table unless you also use the match column.

There are two settings for blending tables that contain both attributes and measures. These are set independently in each visualization based on what columns are used in the visualization. The settings are All Rows and Matching Rows and they describe which source rows the system uses when returning data to be visualized.

The system automatically assigns data blending according to the following rules:

  • If the visualization contains a match column, then the system sets sources with the match column to All Rows.
  • If the visualization contains an attribute, then the system sets its source to All Rows and sets the other sources to Matching Rows.
  • If attributes in the visualization come from the same source, then the system sets the source to All Rows, and sets the other sources to Matching Rows.
  • If attributes come from multiple sources, then the system sets the source listed first in the project's elements panel to All Rows and sets the other sources to Matching Rows.