2 Replies Latest reply: Sep 16, 2013 5:51 AM by Neil Gulliver RSS

    INSERT COLUMS PREVIOUS DATA

    Iñigo Elviro Bodoy

      Hello:

       

      I need the help of somebody for making a script.

       

      I have two tables:

       

      ProductProduction Date
      A01/01/2013 01:45
      B01/01/2013 01:49
      C01/01/2013 01:56

       

      ReelConsume Date
      101/01/2013 01:40
      201/01/2013 01:43
      301/01/2013 01:47
      401/01/2013 01:53

       

      I would like to insert the previous two reels consumed to each product in the script.

       

      In other words:

      ProductProduction DateReel 1Reel 2
      A01/01/2013 01:4512
      B01/01/2013 01:4923
      C01/01/2013 01:5634

       

      How can I do?

       

      I am trying with ApplyMap but without succesfull.

       

      Thanks in advance