Date Gaps Fixed, Need to Replicate Field Data

BruceT — Tue, 21 Jun 2022 14:44:45 GMT

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.

topic Date Gaps Fixed, Need to Replicate Field Data in QlikView

Date Gaps Fixed, Need to Replicate Field Data