3 Replies Latest reply on Jul 19, 2016 1:18 PM by Luciano Vasconcelos

    Data Source Join

    Govind Ramchetty

      Dear Friends

      I have 2 tables A and B

       

      Table A

      Year -- Amount

      2010--100

      2011--4000

      2012--2000

       

      Table B

       

      Year--Sales

      2010--200

      2010--1000

      2010---1200

      2011--100

      2011--2000

      etc...

       

       

      When we joining into DS both tables

      My data preview shows like

       

      A table Year,B table Year,Sales,Amount

      2010,2010,200,100

      2010,2010,1000,100  (See here duplicating Amount bcos of this when we sum in A table based on 2010, it will add 3 times.(bcos 3 time entry available in B table)

       

      How can fix this issue.

      When we do sume in A table based on Year.It should be 1 entry.