Skip to main content
2 answers
  1. Sep 7, 2022, 11:36 AM

    @krishnapriya Arisetti​ Hi Krishnapriya

     

    As per @Jim Dehner​ 's answer to your question, using a blend to combine the two data sources will result in a behavior different to the join. As a side by side comparison,

    1. Join will combine the two data sources and then aggregate
    2. Blend will aggregate and then combine

     

    Because of this difference, Blending is used in cases where the two data sources are at different levels of aggregation. For an example, please consider this example below.

     

    @krishnapriya Arisetti​ Hi Krishnapriya As per @Jim Dehner​ 's answer to your question, using a blend to combine the two data sources will result in a behavior different to the join.In this example, between the Sales Record and Sales Target for Each Brand, we can read that both data sources are at different aggregation level. Sales Record speaks to each individual Models sold under each Brand. However, the Sales Target for Each Brand data source is speaking to the individual Brand in entirety with no regard for individual Models sold.

     

    Therefore, in order to correctly allocate the sales target information for each of the brands, we cannot join this data, but instead we will need to blend it so that the secondary data source (i.e. Sales Target for Each Brand) is joined to the primary data source in an already aggregated format.

     

    This ensures that a sales target of 900 for Brand A remains at a constant 900 irrespective of how many records of Models sold exist for Brand A in the primary data source.

     

    Using these two data sources, I have created a sample workbook, which has resulted in this crosstab.

     

    Image 02Please note that the blending will only assign a constant 900 to the Brand A, despite there being 2 Models (A-11 and A-25) being sold for this Brand in the Primary data source. It therefore does not sum to 1800 as a sales target for Brand A, but remains as 900.

     

    The same principle applies for Brand C. The secondary indicated a total sales target for Brand C to be 800. According to the Primary data source, Brand C has a total of 2 Models being sold. Despite this, the combined table shows a constant sales target of 800 across the entire Brand C sales.

     

    This can be interpreted as follows.

     

    Image 03 

    This view will explain why the total for the Sales Target column is not 3,650. The correct total is 1,950.

     

    If you need the Sales Target column total to be 3,650 then you will need to combine the two data sources by joining them.

     

    I hope this helps.

0/9000