4 Replies Latest reply: Mar 19, 2014 5:45 AM by Sunil Chauhan RSS

    Load first 2 records in a group

      Hi,

      anyone have any idea how to load only the first 2 records according to the latest birthday of every group?

       

      Expected Result:

      For Group 1, Alice,Jon

      For Group 2, David,Derrick

      For Group 3, Serene,Rachel

       

      Dataset:

       

      NameBirthdayGroup
      Alice01/01/871
      David02/03/872
      Jason29/04/873
      Jon01/04/871
      Derrick03/05/872
      Aaron17/07/872
      Jerome20/09/871
      Serene23/02/873
      Rachel21/04/873

       

      Thank you.