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.

[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.