1 Reply Latest reply on Apr 12, 2016 2:09 AM by lenaic.ridinger

    Same customer having index difference of 3 and lesser

    Ken Koh

      hi like to seek your advise.

       

      There are 2 questions for your advise.

       

       

      1. I have the Customer and date data (Table 1) and like to match each date with an index (Refer to Table 2)

       

      2. From Table 2, i like to know who are the same customer having index difference of 3 and lesser.

       

      Table 1

        

      CustomerDate
      A14/04/2014
      B14/05/2014
      C14/06/2014
      D14/07/2014
      A14/08/2014
      B14/09/2014
      C14/10/2014
      D14/11/2014
      A14/12/2014
      B15/01/2015
      C15/02/2015
      D15/03/2015
      A15/04/2015
      B15/05/2015

       

      Table 2

         

      CustomerDateIndex
      A14/04/20141
      B14/05/20141
      C14/06/20141
      D14/07/20141
      A14/08/20142
      B14/09/20142
      C14/10/20143
      D14/11/20143
      A14/12/20143
      B15/01/20154
      C15/02/20154
      D15/03/20154
      A15/04/20155
      B15/05/20155