2 Replies Latest reply: Oct 16, 2013 8:49 AM by Tresesco B RSS

    Retail data identify the most recent purchase by CustID

      Hi All,

       

      I have a table, CustID, Date of Purchase, ProdID, Quantity

       

      Now I want to add few more columns identifying the most recent purchase done by same customer for that ProdID and its quantity.
      This will help me identify number of days since last purchase for a product.

       

      So the final table should look like:

       

      CustIDProdIDDtOfPurQuantityPrevDtOfPurPrevQuantity
      123P101-01-201310--
      123P203-04-201320--
      123P103-04-2013501-01-201310
      123P205-06-2013503-04-201320
      123P305-06-201310--

       

      How do I load table to achieve this.

       

      Please help