2 Replies Latest reply on Oct 19, 2018 8:54 AM by Ankit Bansal

    create a primary key by field

    ni tempe

      I have data as below

      I have repeat values in employee field.

       

       

       

      employee age division project

      A 5 accounts x

      A 5 accounts y

      A 5 accounts z

      B 10 HR x

      B 10 HR y

       

       

      How could I create a secondary key (count rows where division and employee are same) as below. I want to find average age by division and count of employees by division. I am thinking that I will filter data by secondary key = 1 and then do my calculations. Let me know if there is a better way to do the same

       

        

      employeeagedivisionProjectsecondary key
      A5accountsx1
      A5accountsy2
      A5accountsz3
      B10HRx1
      B10HRy2