Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Are above information sufficient?
I would really appreciate if someboday could have a look and help me with this.
Thank you!
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