3 Replies Latest reply: Aug 30, 2016 5:16 PM by Andrew Walker RSS

    load the record which has max occurrence

    Josh Chang

      Hello

       

      I try to create a scrip to load only the records which have the max occurrences.

      For example,

      NameTagDate
      A88805-30-2015
      A88805-29-2015
      A88805-14-2015
      A88806-12-2015
      A77696-1-2015
      B11136-5-2015
      B11136-7-2015
      C99986-1-2015
      B22208-17-2015
      C12346-15-2015
      C12342-10-2015
      B11139-16-2015
      D543010-9-2015
      D11248-20-2015

       

      After load

       

      NameTag
      A8880
      B1113
      C1234
      D5430

       

      Date doesn't matter here.

       

      thanks,

      Josh