calculate-time-difference
Description
calculate-time-difference
adaptor calculates the time difference between two datatable columns (column one - column two), using a specified unit of measurement (defaults to day
).
Note that the order of columns selected is important for the output values.
Inputs
data
Type: datatable
Required: Yes
The datatable containing two date/time columns.
column one
Type: text
Required: Yes
The name of the column containing reference date/time values.
column one format
Type: text
Required: No
The format of data in column one based on Unicode Technical Standard #35. If unspecified, defaults to ISO 8601 date/time.
column two
Type: text
Required: Yes
The name of the column containing date/time values.
column two format
Type: text
Required: No
The format of data in value column based on Unicode Technical Standard #35. If unspecified, defaults to ISO 8601 date/time.
difference column
Type: text
Required: No
The name of the new column containing time difference values. If unspecified, defaults to difference
.
difference unit
Type: text
Required: No
The unit of time measurement. Possible values are years
, quarter
, months
, weeks
, days
, hours
, minutes
, seconds
, or milliseconds
. If unspecified, defaults to days
.
Outputs
data
Type: datatable
A datatable with the new column added.
Examples
Example 1: Default behaviour.
Inputs:
data
:
Sample A
2020-11-01
2020-11-21
Sample B
2020-12-11
2020-12-19
Sample C
2020-12-11
2020-12-11
column one
: Sequence date
column one
: Received date
Outputs:
data
:
Sample A
2020-11-01
2020-11-21
20
Sample B
2020-12-11
2020-12-19
8
Sample C
2020-12-11
2020-12-11
0
-> Calculated the time difference between the two datatable columns Sequence date
and Received date
.
Use Cases
Calculating the time between patient admission to the hospital and the sample date of the first positive sample
Calculate a person's age
Use pharmaceutical expiry dates to predict potential stock outs
Sort or filter data based on time differences
Last updated