ColumnValuesToBeBetween

Type

transform

Class

fire.nodes.quality.NodeCheckColumnValuesToBeBetween

Fields

Name	Title	Description
cols	Column Name	The column name.
min	Min	The minimum value of column.
max	Max	The Maximum value of range
weightage	Weightage	Weightage

Details

Column Values To Be Between Node

Overview:

The Column Values To Be Between node checks if the values in a specific column are within a specified range. This is useful for data quality checks and ensuring data integrity.

Input:

Column Name: The name of the column to check.

Min: The minimum allowed value.

Max: The maximum allowed value.

Output:

The node will flag records where the specified column value is outside the defined range.

Examples

Example:

Let’s assume we have a column named age and we want to identify records where the age is less than 0 or greater than 120.

Configure the Node:

Column Name: age

Min: 0

Max: 120

Node Execution:

Records with an age less than 0 or greater than 120 will be flagged.