3 Replies Latest reply: Nov 8, 2014 6:37 AM by Robert Hutchings RSS

    Load only Distinct and recent values only???

    ashok Velisetty

      Hi All,

       

      I want load only distinct and recent values only while loading data.

       

      see below example for more clarity.

       

      Input:

      LocationMonthYearQty
      A8201410
      A8201410
      B820145
      B8201410
      B820147
      C8201412
      C8201420

       

       

      Output:

       

      Location   Month    Year    Sum(Qty)

      A                  8           2014     10

      B                  8           2014      7

      C                  8           2014      20

       

       

      Thanks,

      Ashok.