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

# Connect with timestamps

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.

• ###### Re: Connect with timestamps

try after removing time stamp from all date fields and then associate.

Regards,

• ###### Re: Connect with timestamps

Hi Prashant,

I need timestamp, the reason is that I want to calculate Production yield on every Dim cycle.

If I remove time, there will be many to many Association.

• ###### Re: Connect with timestamps

Hi,

can you post required output.

Regards,

• ###### Re: Connect with timestamps

what was the logic behind 3 and 4 th line output????

Regards,

• ###### Re: Connect with timestamps

If there is always similar no of rows in machine 1 and machine 2

then you while loading data you can use rowNo() to assign row no to each row, then associate with row no()

Regards,

• ###### Re: Connect with timestamps

No, the rows are not similar and can not be compared With each other.

• ###### Re: Connect with timestamps

Hi Steffan,

Please clarify the association between the two time intervals.

For Dim value 50-150 the interval [mintime, maxtime] in contained in [start, end].

For 63-125 neither interval is contained in the other, there is an overlap.

If an overlap is enough to give an association then the interval

[mintime, maxtime] = 2017-08-23 22:35 to 2017-08-24 00:09

overlaps the first two [start, end] intervals.

2017-08-22 14:45 to 2017-08-23 22:42

and

2017-08-23 22:43 to 2017-08-24 00:25

Cheers

Andrew

• ###### Re: Connect with timestamps

Hi Andrew,

I'll try to clarify, End time on machine2 is when the cycle is finished. Start time on machine2 will then be the same on next cycle. Start time on machine2 is like the machine is now ready for next cyckle. End time is when they have received the last piece and reset the cycle.

In this example 63-125 start at 2017-08-23 22:35 in machine1 and the last piece was received 2017-08-24 00:25.

Machine1 start a New cycle (44-85) 2017-08-24 00:16 but will not received to machine2 until 2017-08-24 00:25

 63-125 2017-08-23 22:35 2017-08-24 00:09 63-125 2017-08-23 22:42 2017-08-24 00:25 44-85 2017-08-24 00:16 2017-08-24 07:16 44-85 2017-08-24 00:25 2017-08-24 07:33

This is tricky, I know, but some of my idea is if I can in somehow "point" in the middle of the timestamps and Connect the machine timestamps With each other.

• ###### Re: Connect with timestamps

Hi Staffan,

Cheers

Andrew

• ###### Re: Connect with timestamps

Of course Andrew

• ###### Re: Connect with timestamps

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

• ###### Re: Connect with timestamps

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.