How add missing date rows

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

For example:

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:

• Blank.
• Copied from the row above.
• Copied from the row below.
• User defined, e.g. ‘0’.

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.