Fill date gaps with last status

[overclocked]

Hi,

I have this table and need to fill the date with gaps.

This is my table

ID	Start	End	Status	Status_Duration	Data_Date
1QPTS	11/2/2021 6:00	11/2/2021 7:21	New Setup	1.35	11/2/2021
1QPTS	11/2/2021 7:21	11/2/2021 11:54	Running	4.55	11/2/2021
1QPTS	11/2/2021 11:54	11/2/2021 14:27	Hold	2.55	11/2/2021
1QPTS	11/2/2021 14:27	11/2/2021 21:22	Running	6.9	11/2/2021
1QPTS	11/2/2021 21:22	11/2/2021 23:03	Idle	1.7	11/2/2021
1QPTS	11/2/2021 23:03	11/3/2021 1:12	Setup	2.2	11/2/2021
1QPTS	11/3/2021 1:12	11/3/2021 6:00	Running	4.8	11/2/2021
1QPTS	11/3/2021 6:00	11/3/2021 11:44	Running	5.7	11/3/2021
1QPTS	11/3/2021 11:44	11/4/2021 6:00	Idle	18.3	11/3/2021
1QPTS	11/6/2021 6:00	11/6/2021 10:34	Idle	4.6	11/6/2021

the table should look like below.

ID	Start	End	Status	Status_Duration	Data_Date
1QPTS	11/2/2021 6:00	11/2/2021 7:21	New Setup	1.35	11/2/2021
1QPTS	11/2/2021 7:21	11/2/2021 11:54	Running	4.55	11/2/2021
1QPTS	11/2/2021 11:54	11/2/2021 14:27	Hold	2.55	11/2/2021
1QPTS	11/2/2021 14:27	11/2/2021 21:22	Running	6.9	11/2/2021
1QPTS	11/2/2021 21:22	11/2/2021 23:03	Idle	1.7	11/2/2021
1QPTS	11/2/2021 23:03	11/3/2021 1:12	Setup	2.2	11/2/2021
1QPTS	11/3/2021 1:12	11/3/2021 6:00	Running	4.8	11/2/2021
1QPTS	11/3/2021 6:00	11/3/2021 11:44	Running	5.7	11/3/2021
1QPTS	11/3/2021 11:44	11/4/2021 6:00	Idle	18.3	11/3/2021
1QPTS	11/4/2021 6:00	11/5/2021 6:00	Idle	24.0	11/4/2021
1QPTS	11/5/2021 6:00	11/6/2021 6:00	Idle	24.0	11/5/2021
1QPTS	11/6/2021 6:00	11/6/2021 10:34	Idle	4.6	11/6/2021

[Chanty4u]

Have a look on below sample

https://community.qlik.com/t5/QlikView-App-Dev/fill-out-missing-dates/td-p/1762804

[MarcoWedel]

maybe also helpful:

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

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