This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
One source contains telematic vehicle data containing registration/event datetime/ event and where it has intersected a geofence I created to identify the pick up and drop off location. It is a continuous stream of data.
The second source contains booking data and includes vehicle registration, pick up and drop off datetime & location.
I am trying to append the booking information onto the telematics but are struggling to come up with a way to insert the booking Number into each data point of the telematic data.
I attach image of what I would like to achieve- All of the yellow values should contain the booking number found at the beginning and end of each block. The red should remain null as there are no bookings in this period.
Any suggestions on how to solve this within a workflow muchly appreciate- Outside a workflow solutions welcome too
After taking a small break I was able to Resolve this using the Generate Rows tool and the min/max values repopulate to help replicate the recordID with the booking Ref. I then joined back onto the data stream