5 Replies Latest reply on Jun 22, 2018 12:24 AM by David Maning

    Using Two datasource to get the sum of feilds

    AMIT AWASTHI

      Hi All,

       

      Need your help in achieving the sum from below data sets.

       

      I have two data set.

       

      Data1:  3 fields

       

      EVENT     Location1     Location2

      a

      LAW
      bLAB
      cLAC
      aHJM
      bHJN

        c

      HJA
      aHJB
      bLAR
      aHJK

       

      Data2:  1 field

       

         ID

      LAW
      LAB
      LAC
      HJM
      HJN
      HJB
      HJA

      Here Id is a connecting field for both the data sources.

       

       

      My requirement is to have below text table (i.e. After filtering out NULL ID)

       

      OR

       

      Simply the count of rows=7 (i.e. again after filtering out NULL ID)

      .

      Any help is appreciated.

       

      Regards,

      AMIT AWASTHI