13 Replies Latest reply: Jun 20, 2015 2:01 AM by kushal chawda RSS

    Check which value is the Min and Max in Load Script

      Hi,

       

      I would like to attach a field to my data, to determined which line has the max value or min value for the combination of ID+Activity in my Script Load:

       

      IDActivityDate
      1A01/01/2015
      1A02/01/2015
      1A03/01/2015
      1B04/01/2015
      2B05/01/2015
      2B06/01/2015
      3C07/01/2015

       

      The result could be something like this:

       

      IDActivityDateRank
      1A01/01/2015Min
      1A02/01/2015
      1A03/01/2015Max
      1B04/01/2015Max/Min
      2B05/01/2015Min
      2B06/01/2015Max
      3C07/01/2015Max/Min

       

      I tried some combination of max and min, but did not get results like this one that i was expecting.

      BR//Marcelo Fonseca