Connect with timestamps

[stabben23]

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.

[effinty2112]

Hi Staffan,

Can you upload your data again as an excel sheet?

Cheers

Andrew

[stabben23]

Of course Andrew

[effinty2112]

Hi Staffan,

                    In your spreadsheet you match these two time intervals with time overlap of 1,122 minutes.

50-100

24/08/2017 16:11

28/08/2017 14:20

24/08/2017 15:37

25/08/2017 10:54

Why is the second interval a better match to the first than the Machine 2 interval that follows?

25/08/2017 10:54

28/08/2017 14:33

The time overlap is 4,539 minutes.

Cheers

Andrew

[stabben23]

Hi Andrew,

I dont match the at all at the moment. I can see that these have to match if I look at the timestamps. But is this case they have finished the cycle at 25/08/2017 10:54 and I dont know why because as You can see there is no New Dim from Machine1.

So even 25/08/2017 10:54- 28/08/2017 14:33 is the same cycle and should be Connected to 50-100.

I dont know if this could be solved, but I thougt that maybe someone have Connect data like this before.