Home > Transforms Nodes > Filter Columns > Transform > Edit Transform Node > Add Transform > Binning
Use binning to transform a continuous variable to a discrete one or to transform a variable with a large number of discrete values to one with a smaller number of discrete values.
Binning is the default transformation.
The types of binning supported depend on the data type of the column:
For numerical data types (NUMBER), these types of binning are supported:
Bin Equal Width Number, the default
Bin Quantile
Custom
For categorical data types (VARCHAR2), these types of binning are supported:
Bin Top N, the default
Custom
For date and time data types (DATE, TIMESTAMP, TIMESTAMP_WITH_LOCAL_ TIMEZONE, and TIMESTAMP_WITH_TIMEZONE), these types of binning are supported:
Bin Equal Width, the default
Custom
Note: The number of bins must be 3 or larger. |
Select the binning type to use. See directions for the type that you selected: