Date Shifter

Shifts date columns by a defined duration or granularity. You can select the date 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 the date forward; negative values shift it backward. Numerical values are interpreted based on the selected granularity.
Often used to adjust timestamps to account for time zone differences or reporting periods.

Options

Date&time columns

The date&time columns whose values are shifted.

Shift mode

Select the shift mode to use.

• Shift value: Uses a date-based shift value.
• Period column: Uses a shift value from a date-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 date-based duration format for details)
• the short letter representation (e.g. '2y 3M 1d'). In this case, for the the letters y, M, and d respectively indicate years, months, and days.
• the long word representation (e.g. '2 years 3 months 1 day').

Column

Select to choose the shift value from a date-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. days, weeks, 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

• 03 OPTIONAL Production data pipeline - Triggered executionKNIME Hub
• 03 OPTIONAL Production data pipeline - Triggered execution - ExerciseKNIME Hub
• 3. propose_alternativeKNIME Hub
• Challenge 9-Processing Invoices at the End of a QuarterKNIME Hub
• JKISeason 4-9 - Processing Invoices at the End of a QuarterKNIME Hub
• Show all 13 workflows

Links

• No links available

Developers