ExpectColumnValuesToBeInBetween

Type

transform

Class

fire.nodes.ge.NodeExpectColumnValuesToBeInBetween

Fields

Name	Title	Description
cols	Column Name	The column name.
min	Min	The minimum value for a column entry length.
max	Max	The maximum value for a column entry length.

Details

Expect Column Values To Between Details

Expect the column entries to be between a minimum value and a maximum value (inclusive).

Keyword Args

Column Name: The column name

Min (comparable type or None): The minimum value for a column entry.

Max (comparable type or None): The maximum value for a column entry.

Notes

Min and Max are both inclusive.

If Min is None, then Max is treated as an upper bound, and there is no minimum value checked.

If Max is None, then Min is treated as a lower bound, and there is no maximum value checked.

Examples

Example

Incoming Dataframe

In this example we have considered a Incoming Dataframe with following rows:

EMP_CD    | Joining AGE   |    Joining Date     |
-------------------------------------------------
E01       |    42         | Jan 01 1979 12:00:01
E02       |    29         | Dec 31 1999 12:00:11
E03       |    35         | Jan 01 2000 12:03:01
E04       |    54         | Feb 01 2000 12:00:01

Configuration #1

Column Name | Min  | Max  |
--------------------------
Joining AGE | 25   | 60   |

The above setup would result in a status of success: true as the condition is satisfied.

Configuration #2

Column Name  |          Min           |          Max           |
----------------------------------------------------------------
Joining Date | Jan 01 1990 12:00:00   | Jan 01 2001 12:00:00   |

The above setup would result in a status of success: false as the condition is satisfied.