3 Replies Latest reply on Jul 24, 2012 10:16 AM by Rob Bisaillon

    Joining 2 extracts

    Rob Bisaillon

      I have a requirement to provide dimensions and measures from two separate extracts into one workbook.  Listed below is a sample of the content in each extract and the desired wookbook output.

       

      Extract 1:

      Agent id

      Agent Name

       

      Extract 2:

      Agent id

      Date of Sale

      Product

      Sale Amt

       

      Sample output in Workbook/Dashboard

       

      Agent id       Agent Name    Date of Sale   Product Sale Amt

      1                  John Doe        2/15/2012      Shoes    10,000

      1                  John Doe        3/15/2012      Clothes  15,000

      2                  Jane Doe        4/15/2012      Belts       5,000

      3                  Charlie Brown  

       

      Can extracts be joined to to provide this level of detail? When I tried Data blending, I got the following output.

      Agent id       Agent Name    Date of Sale   Product   Sale Amt

      1                  John Doe        *                    *             25,000

      2                  Jane Doe        4/15/2012      Belts         5,000

      3                  Charlie Brown  Null              Null