How add missing date rows

Easy Data Transform can add missing date rows using the Sequence transform:

Add missing date rows in sequence

For example:

Example adding missing date rows into a date table

The rows added can be based on the minimum and maximum date values derived from the current dataset or defined by the user in the format yyyy-M-d.

The new values added can be:

See the video above for more details.

If you set new values to blank, then you can use the Impute or Interpolate transforms to set the values based on the row values in the original dataset.

The Sequence transform can also be used to add missing integer (whole number) values in a sequence.

Easy Data Transform can also help with reshaping, merging, cleaning, filtering and enriching your data, without coding.

Try it free now!

Windows Logo Windows Download

v1.46.5 for Windows 11 / 10 / 8 / 7 (47 MB)
Zip file version

Apple Logo Mac Download

v1.46.5 for Mac 14.x to 10.13 (79 MB)

No commitments.
You can uninstall any time.
You don't even have to give us your email address.

Questions or problems?