A set of essential tools for data cleansing and removing obvious noise are functions that let you set filters and boundaries. As you study the functions below, be aware of the way we deal with outliers: the either get removed from the returned data set or set to zero, null, or a value you provide.
The Trim_Value_Stream(attribute_reference, low bound, high bound) Function
The trim function will remove values that are outside the low/high bound interval. Values equal to the low or high bound are kept.
Example: trim_value_stream($.inlet_temperature, 60, 65)
The Crop_Value_Stream(attribute_reference, low bound, high bound) Function
The crop function will set to NULL values that are outside the low/high bound interval. Values equal to the low or high bound remain unchanged.
Example: crop_value_stream($.inlet_temperature, 60, 65)