Hello all,

i have the issue that I want to join two different tables based on a time filter.

Table 1 describes different materials going to different Targets with an exact event-time.

Unique-ID | Eventtime | Target 1|

Unique-ID | Eventtime | Target 2|

Unique-ID | Eventtime | Target 1|

Table 2 is a status-table which is updated in irregular intervals (Date_1, Date_2, Date_3..) and contains for each Target a string with either Mode_A oder Mode_B.

Target 1 | Date_1 | Mode_A

Target 2 | Date_1 | Mode_A

Target 1 | Date_2 | Mode_A

Target 2 | Date_2 | Mode_B

Target 1 | Date_3 | Mode_B

Target 2 | Date_3 | Mode_A

I now want to join table 2 into table 1 and match the Mode-A to each unique-ID based on the condition, that the Eventtime is between the respective Date-Intervalls.

Any Idea how to solve this?