Easy Data Transform can add missing date rows using the Sequence transform:
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.
v1.43.0 for Windows 11 / 10 / 8 / 7 (46 MB)
v1.43.0 for Mac 13.x to 10.13 (78 MB)
Questions or problems?