5 Replies Latest reply: Jun 24, 2016 11:48 AM by John Witherspoon RSS

    How to show the latest data, using script?

    Prashanth Reddy

      Hi,

       

      I have a scenario, where I am getting daily files to be loaded, in which I have to show only the latest records based on Name and ID.

      For example:

       

      ID     Name     Action          SourceFilename

      12     A          Immediate     May12

      12     A          Immediate     May13

      15     B          Future          May12

      15     B          Immediate     May13

       

      Expected Output:

       

      ID     Name     Action          SourceFilename

      12     A          Immediate     May13

      15     B          Future          May12

      15     B          Immediate     May13


      I have different action for name B, so I am expecting 2 records as it is from the data.


      thanks for any help on this


      Regards

      Prashanth