Time Sequence Processor

Modified on Tue, 30 Nov 2021 at 02:38 PM


The Time Sequence Processor generates a continuous and ordered (ascending) time sequence for given start and end dates.


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)!!


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.


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.


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


Example Configuration


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article