How to Add Missing Values in a Continuous Sequence

Here’s Excel file book1.xlsx:

We need to add the missing dates in column 4 to get the following table:

It’s convenient to do this in esProc.
Download esProc installation package and free DSK edition license HERE.

Write script p1.dfx in esProc:

A1 Import data of book1.xlsx; @w option enables reading data as a sequence of sequences.

A2 Get the complete sequence of dates according to the largest date and the smallest date.

A3 Align A1’s table sequence to A2’s sequence of dates.

A4 Populate dates into empty rows.

A5 Export result to book2.xlsx.

2. Execute the script to get the expected result.