Connecting time slots with time stamp data

[gmiro]

Hi!
I'm new to the forum, and I'd like to get any help regarding this issue. I have two datasets connected by time. One of them is a time slot with a status for each of them:

Category	Event	Initial time	End time	Duration
Condition	A	11/11/2020 00:00:00	11/11/2020 01:49:21	01:49:21
Condition	B	11/11/2020 01:49:21	11/11/2020 01:51:29	00:02:08
Condition	A	11/11/2020 01:51:29	11/11/2020 02:14:41	00:23:12
Condition	B	11/11/2020 02:14:41	11/11/2020 02:14:56	00:00:15

The second table is a timestamp typical table for time-based data:

Date	Data A	Data B
11/11/2020 0:00:00	25	35
11/11/2020 0:10:00	45	20
11/11/2020 0:20:00	20	25
11/11/2020 0:30:00	32	30
11/11/2020 0:40:00	12	45
11/11/2020 0:50:00	45	210
11/11/2020 1:00:00	50	220
11/11/2020 1:10:00	241	235

How I can connect each row of the second table with the appropriate data from the 1st table?

Any help would be appreciated. Thanks!

[amitchandak · Accepted solution]

@gmiro , You can get data from first table into second table like

maxx(filter(first, second[Date]>= first[Initial time] && second[Date]<= first[End time]), first[Duration])

also refer the way to get data from one table to another - https://www.youtube.com/watch?v=czNHt7UXIe8