Compute duration

The Compute duration step allows to compute the duration (in days, hours, minutes or seconds) between 2 dates in a new column.

Step parameters

• New column name(string*): the new column to be created for the computation result

• Start date column column(string)*: the starting date

• End date column column(string)*: the ending date

• Duration in (integer)*: the duration units (days, hours, minutes or seconds)

Example

Input

Date - compute duration

Configuration

{
  "new_column_name": "compute_duration",
  "start_date_col": "start_date",
  "end_date_col": "end_date",
  "duration_in": "days",
}

Output

Date - compute duration output