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,



      Thanks in advance