Time Shifter

Shifts time columns by a defined duration or granularity. You can select the time columns to shift and specify the shift value as a duration column, a numerical column with a granularity, or a constant numerical value with a granularity. Positive values shift forward; negative values shift backward.
Commonly used to adjust times for time zone corrections or shift schedules.

Options

Date&time columns

The date&time columns whose values are shifted.

Shift mode

Select the shift mode to use.

• Shift value: Uses a time-based shift value.
• Duration column: Uses a shift value from a time-based duration column.
• Number column: Uses a numerical column to scale a configurable time unit.

Shift value

Select to insert a format string to use as constant shift value. The inserted string can be either in:

• the ISO-8601 representation (see time-based duration format for details)
• the short letter representation (e.g. '4H 5m 6s'). In this case, the letters H, m, and s respectively indicate hours, minutes, and seconds.
• the long word representation (e.g. '4 hours 5 minutes 6 seconds).

Column

Select to choose the shift value from a time-based duration column.

Column

Select to choose the shift value from a numerical column. The shift value will be scaled by the selected granularity.

Granularity

The granularity (i.e. hours, seconds, etc) of the shift.

Output columns

Depending on this setting, the output columns will either replace the modified columns, or be appended to the table with a suffix.

• Replace: Replaces the selected columns by the new columns.
• Append with suffix: Appends the selected columns to the input table with a new name that is the previous name plus the provided suffix.

Output column suffix

The suffix to append to the column names of the new columns.

Views

This node has no views

Workflows

• No workflows found

Links

• No links available

Developers