2 Replies Latest reply on Aug 31, 2018 2:45 AM by meenu choudhary

    Filter out duplicates by multiple dimensions

    balaji sj

      Hi People

       

      I have columns in the data namely (floor id, name, occupation, salary, company). I need to filter out duplicates based on three columns (floor id, name, occupation) and calculate sum of salary by company.

       

      Final Output required,

      test3.PNG

       

      Thanks in advance

      Balaji.S.J