13 Replies Latest reply: Aug 31, 2017 10:03 AM by Staffan Johansson RSS

    Connect with timestamps

    Staffan Johansson

      Does anyone have experience to Connect data With timestamp which not match. I need a function so I can map a Field(Dim) into another table.

      This is two machines, machine1 has a start and end time, machine1 producing pieces to machine2, machine2 also have a start and end time. Machine1 always start first even if starttime on machine2 has a previous starttime. Machine2 end is when everything is produced and a New cycle begins.

      You dont need to solve evrything here, just point me in the right direction on what function I should use here.

      As you can see there is sometimes overlapping times, but the logic is as above mentioned.