Inserts additional rows between two consecutive rows. Number and auto-fill value of rows depends on the interval defined (default=minutes).
Example

Example Input
dim_A | dim_B | time_1 |
AAA | DDD | 2019-01-01 |
BBB | EEE | 2019-01-02 |
CCC | FFF | 2019-01-05 |
Example Output
dim_A | dim_B | time_1 |
AAA | DDD | 2019-01-01 |
BBB | EEE | 2019-01-02 |
2019-01-03 | ||
2019-01-04 | ||
CCC | FFF | 2019-01-05 |
I Ain't Afraid of No Code!
[
[
"filltimegaps",
{
"interval": "days",
"presorted": false,
"subtable": null,
"timestamp_field": "time_1",
"timestamp_format": "%Y-%m-%d",
"_comment": null
}
]
]
param str interval: Can be one of [minutes, hours, days]. Having 2 consecutive rows with a time gap of 1 day and interval==hours would produce 23 additional rows in between.
param boolean presorted: Speeds up operation in case timestamp_field is already sorted.
param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).
param str timestamp_field: Name of column with date(-time) information.
param str timestamp_format: Format of date(-time) information in timestamp_field.
param str comment: A comment that will appear in the Transformation UI.
Comments
0 comments
Article is closed for comments.