Timeliness Check - Latest

Data360 DQ+ Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 DQ+
Version
Latest
Language
English
Product name
Data360 DQ+
Title
Data360 DQ+ Help
Copyright
2024
First publish date
2016
ft:lastEdition
2024-07-09
ft:lastPublication
2024-07-09T15:09:58.774265

The Timeliness Check node is used to check whether the amount of time between two fields surpasses an acceptable level. The node produces a new field containing Boolean values for each timeliness check that is written. If the difference between the two chosen fields is less than or equal to the acceptable interval, the record is considered timely and a True value is returned. Conversely, if the difference between the two chosen fields is greater than the acceptable interval, the record is not considered timely and a False value is returned.

Properties

Check Result Field Name

This is the name of the Boolean field the node will produce for the Timeliness Check.

Start Time Field

This is the field containing start dates to be used in the Timeliness Check. Only Date, DateTime, or Time fields can be used.

End Time Field

This is the field containing end dates to be used in the Timeliness Check. Only Date, DateTime, or Time fields can be used.

Allowed Time Difference

This is the acceptable difference between the Start Time Field and the End Time Field to check for. If the difference between the Start Time Field and the End Time Field is less than or equal to the Allowed Time Difference, the Timeliness Check will return True; otherwise, it will return False.

Timeliness Check Example

You have the following data set:

orderDate

shipDate

08/08/2017

08/10/2017

08/09/2017

08/12/2017

08/10/2017

08/14/2017

For this data set, we could define a timeliness check with a Check Result Field Name of ShippedOnTime. For the Start Time Field we could use orderDate, and for the End Time Field we could use shipDate. For the Allowed Time Difference we could set an interval of three days, to check whether an order has shipped within three days of being placed.

The result set would be as follows:

orderDate

shipDate

ShippedOnTime

08/08/2017

08/10/2017

True

08/09/2017

08/12/2017

True

08/10/2017

08/14/2017

False

Note that, as with other Data Quality check nodes, multiple timeliness checks may be written per Timeliness Check node.