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 Input

Workflow

Example Configuration

Result