Overview
The Time Sequence Processor generates a continuous and ordered (ascending) time sequence for given start and end dates.
Input
The processor takes a valid dataset as input with two columns that contain datetime values. One column contains the start, the other the end-date/time.
Note that the processor only works on small datasets (100 rows or smaller)!!
Configuration
Start Date: Select a column that contains the start datetime.
End Date: Select a column that contains the end datetime.
Unit: Option to choose in which intervals the sequences are created. Possible options: Milliseconds, Seconds, Minutes, Hours, Days, Weeks, Months, Quarters, Years
Locale: Specifies the locale used for interpreting the start day of the week. The default locale code is "en".
Sequence Column Name: The name for the column that contains the created time sequence.
Only Weekdays: When checked, only weekdays will be included in the generated sequence. The setting is supported only for following "Unit" types: Milliseconds, Seconds, Minutes, Hours, Days. Using it for other unit types generates a warning.The workflow will continue with setting ignored.
Output
The processor output is the input dataset, with two columns appended at the left hand side. One "Index" column and a column with the generated sequence.
Example
As example we take a table with two columns that contain dates as text format, that first will be converted to datetimes with the Data Type Conversion processor. Then a time sequence with the unit "Day" will be created.
Example Configuration
Result