3 Replies Latest reply on Oct 6, 2016 7:37 AM by Dmitry Chirkov

    Union of two fields from different data source

    Madhumitha Palanisamy

      Hi

      I am having two date fields in different data source.

      Example:

      Data source 1:

      Date1

      Jan 2011

      Feb 2011

      Mar 2011

      Jul 2012

       

      Data source 2:

      Date1

      Jan 2011

      Apr 2011

      Jan 2012

      Sep 2012

       

      I am linking(using data blending) these data sources using the Date1 field.

      I am using a table to display information

      In the pivot table I am displaying date1 from Date source1,sales from Data source1 and sales from Data source2.

      But I am not getting the sales for the dates present in Data source 2.

       

      I am expecting the result like this,

       

      Date               Sales1          Sales2

      Jan 2011        $10,000       $20,000

      Feb 2011        $20,000          

      Mar 2011        $15,000          

      Apr 2011                            $30,000

      Jan 2012                           $15,000

      Jul 2012         $50,000           

      Sep 2012                           $25,000

       

      But the actual result is like this,

       

      Date               Sales1          Sales2

      Jan 2011        $10,000       $20,000

      Feb 2011        $20,000          

      Mar 2011        $15,000          

      Jul 2012         $50,000           

       

      So It is taking the sales for corresponding date from Data source1 only.

      So I need the union of the date field in two different data sources.

      Any answers will be welcomed.