Increments Date in new column.
Example

start date | end date | metric_1 |
2017-07-24 | 2017-07-25 | 111 |
2017-07-31 | 2017-08-03 | 222 |
start date | end date | metric_1 | new_date_field |
2017-07-24 | 2017-07-25 | 111 | 2017-07-24 |
2017-07-24 | 2017-07-25 | 111 | 2017-07-25 |
2017-07-31 | 2017-08-03 | 222 | 2017-07-31 |
2017-07-31 | 2017-08-03 | 222 | 2017-08-01 |
2017-07-31 | 2017-08-03 | 222 | 2017-08-02 |
2017-07-31 | 2017-08-03 | 222 | 2017-08-03 |
I Ain't Afraid of No Code!
[
[
"timecast",
{
"date_format": "%Y-%m-%d",
"increment": 1,
"interval": "days",
"subtable": null,
"fieldname": "new_date_field",
"end_field": "end date",
"start_field": "start date",
"_comment": null
}
]
]
param str date_format: Format in which date will be parsed into field_name.
param int increment: Increment by which to increase every subsequent row, default is 1.
param str interval: Defines the format for interval gaps (e.g. daily, weekly, yearly).
(e.g. interval "days" and increment "2" would create a new row for every alternate day.)
param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).
param str fieldname: New date field to be created
param str end_field: Field name for end of period. Must be type datetime.
param str start_field: Field name for start of period. Must be type datetime.
param str comment: A comment that will appear in the Transformation UI.
Comments
0 comments
Article is closed for comments.