Hi, I have two tables like these:
Worker:
Name,
DateTime_Initial,
DateTime_Final,
Equipment
Production:
Equipment,
Date_Time,
Lot_Number
The first table has the names of the workers for each of the equipments in each date/time. It won´t happen to have more than a worker in the same equipment in the same date/time
The second table has the production of each equipment and it will have dozens of lines for each equipment by hour.
I need to have just one table linking the worker with the production, so I´ll know in the end wich is the production for each worker.
I´ve tried to use interval match but I don´t know how to put the equipment in the logic.
Best
Robson
