5 Replies Latest reply: Jul 4, 2017 3:27 AM by Ibrahim Aslan RSS

    Creating a new order number

    Ibrahim Aslan

      Hi Friends,

       

      we got many data from our machines and we want to make a report.

       

      I have a table for example with this data:

       

      Timestamp

      Program Number

      (is specific for a Material and not a order number)

       

       

      20.08.2015 06:00:00

      64

      20.08.2015 06:10:0064
      20.08.2015 07:00:0064
      20.08.2015 07:30:0064
      ...
      21.08.2015 01:00:0064
      21.08.2015 01:10:0022
      21.08.2015 01:30:0022
      ...22
      21.08.2015 10:10:0022
      ...
      30.08.2015 14:10:0064
      ...

       

      We want now to see, which productions are in the same order number and which are new.

      The new table should be like this: Date is the first time when this Order started:

      Date

      Program Number

      (is specific for a Material and not a order number)


       

       

       


      Order Number

      20.08.2015

      64

      1
      21.08.2015222
      30.08.2015

      64

      3

       

       

       

      How can I do this? I have tried it with the peek function, but it does not work.

       

      Thx