Generate Missing data

[manojkulkarni]

Hi All,

I have below data for which i need to generate data missing between the dates till today so that we can plot historical chart on this. Appreciate any suggestion or solutions on the same.

Temp:

Load * inline [

CaseID, CompletedDate,             Value,   CDate,  TestResult_PointID

233579,              18-Sep-2020,     Passed, 18-09-2020,       786133

233579,              16-Oct-2020,     Failed, 16-10-2020,       786133

233579,              03-Nov-2020,    Passed, 03-11-2020,       786136

233579,              17-Nov-2020,    Aborted, 17-11-2020,       786134

233579,              19-Nov-2020,    Passed, 19-11-2020,       786134

];

[Kushal_Chawda]

@manojkulkarni  see the attached

[manojkulkarni]

Thanks for the document. It is useful