Date Gaps Fixed, Need to Replicate Field Data

[BruceT]

Hi All

My Fact Table Below (Qlikview). I have extracted data from a Planning Board in our ERP System, using SQL I ascertained jobs sometimes Start on one day and end on another day (Date Gaps) and thus create a record for the Start Date and End Date. 

As you can see 0.8 hours fall on 27 June 2022 and 5.5 hours fall on 1 July 2022. 

I filled the Date Gaps (28-30 June) with Hours = 24, but just cannot populate the JobNum and Machine in the empty fields in my Fact Table...any advice would help, thanks.

[MarcoWedel]

maybe helpful:

https://community.qlik.com/t5/Qlik-Design-Blog/How-to-populate-a-sparsely-populated-field/ba-p/14706...

https://community.qlik.com/t5/QlikView-Documents/Generating-Missing-Data-In-QlikView/ta-p/1491394