Cut data to match it to shift intervalls

[Joe13]

Hi all,

I need some support regarding matching machine data to shift intervalls.

Origin data contains data from the ERP-system as follows:

Then I have a table where Start and End for each shift is defined:

Target is to cut all events - where necessary - to match them with shift intervalls.
I did it manually in excel. Yellow marked timestamps should be created by Qlik and also data for field #Duration should be calculated accordingly.

The complete dataset is quite large (approx. 30 M data records).

I already check for example this post https://community.qlik.com/t5/QlikView-Documents/IntervalMatch-and-Slowly-Changing-Dimensions/ta-p/1..., but I did not get it how to cut the data and like  I need it in my case.

Also I'm not sure if intervalmatch-function in general is the right approach here.

Thank you very much in advance for your kind support!

[Joe13]

Are above information sufficient?

I would really appreciate if someboday could have a look and help me with this.

Thank you!

[Brett_Bleess]

John, try the Design Blog area, these may prove more helpful than the other posts you had found:

Base link you can search on: https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

I noticed you did have a couple of the ones I had initially, so I swapped those for a couple of others that might give you other ideas here.  

Regards,
Brett