16 Replies Latest reply: Jun 12, 2015 7:17 AM by Senthil Kumar RSS

    MTD

      Hi

       

      ALT_DATE

      MAR

      AACTION

      2015-06-02T00:04:25.76Z

      150401SCBLAEADBDIF0724514887

      OK

      2015-06-02T00:18:29.69Z

      150401SCBLAEADBXXX0724515370

      HOLD

      2015-06-01T00:20:34.60Z

      150401SCBLAEADBXXX0724515376

      OK

      2015-06-01T00:20:34.60Z

      150401SCBLAEADBXXX0724515379

      OK

      2015-05-01T00:57:31.61Z

      150401SCBLAEADBXXX0724515584

      CANCEL

      2015-05-01T01:03:21.03Z

      150401SCBLAEADBXXX0724515592

      OK

      2015-05-02T01:03:21.03Z

      150401SCBLAEADBXXX0724515593

      OK

      2015-05-03T01:03:21.03Z

      150401SCBLAEADBXXX0724515599

      SVET

      2015-05-04T01:03:21.03Z

      20150401N008818979-1

      OK

      2015-05-03T01:03:21.03Z

      150401SCBLAEADBXXX0724515600

      OK

      2015-04-06T01:19:21.15Z

      150401SCBLAEADBXXX0724515602

      ERRIDE

      2015-04-01T01:23:20.98Z

      150401SCBLAEADBXXX0724515606

      OK

       

      In the above sample data , We  need to find the MTD count of DISTINCT MAR with AACTION = OK , CANCEL, HOLD  for last 2 Months