Duration to String

Converts duration columns to string representations. Supported formats include ISO 8601, a short form (using letters), or a long form (using words). This helps make duration data more readable.
Often used to display human-readable durations in reports or data apps.

Options

Duration columns
The columns to convert to a string.
Output format
The format of the output string.
  • ISO 8601: Formats the durations using the ISO-8601 representation, e.g. 'P2Y3M5D'.
  • Whole words: Formats the durations using words to represent them, e.g. '2 years 3 months 5 days'.
  • Single letters: Formats the durations using letters to represent them, e.g. '2y 3M 5d' (Date-based duration: y: years, M: months, d: days; Time-based duration: H: hours, m: minutes, s: seconds).
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.

Input Ports

Icon
Input table containing duration columns.

Output Ports

Icon
Output table with duration columns converted to string columns.

Popular Predecessors

  • No recommendations found

Popular Successors

  • No recommendations found

Views

This node has no views

Workflows

  • No workflows found

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.