TD_​BinCodeFit

fastpath function to generate required bins and binning parameters to be used by TD_BincodeTransform for converting the numeric data into categorical data. Supports two methods {EQUAL-WIDTH, VARIABLE-WIDTH}

Options

LabelColumn
Specifies the FitInputTable column which contains label for which bins are specified. Default value is Label.
LabelPrefix (strings seperated by new line)
Specify the labelprefix to be used when MethodType is EQUAL-WIDTH. If one value is provided, it applies to all target columns. If more than one value is specified, Labelprefix values applies to TargetColumns in the order specified by the user. Default values are target column names.
MaxValueColumn
Specifies the FitInputTable column which contains Max Value for the specified bins. Default value is MaxValue.
MethodType
Specify the MethodType which will be used for histogram computation. Supported MethodType are {EQUAL-WIDTH, VARIABLE-WIDTH}.
MinValueColumn
Specifies the FitInputTable column which contains Min Value for the specified bins. Default value is MinValue.
NBins (integers seperated by new line)
Specifies the number of bins to be used when MethodType is EQUAL-WIDTH, not needed for VARIABLE-WIDTH. If one value is provided, it applies to all target columns, if more than one value is specified, NBins values applies to TargetColumns in the order specified by the user.
Output Schema
Output Schema, if Volatile is true then use user login as the schema.
Output Table
Output Table
VAL Location
VAL Location
TargetColNames
Specifies the FitInputTable column which contains column Name for which bins are specified. Default value is ColumnName.
TargetColumns
Specifies the input table columns for which bins information and binning parameters needs to be generated.
Volatile
Specifies whether the table should be a VOLATILE table. If true, then the table is automatically deleted, otherwise it is users responsibility to remove or clean it up for space.

Input Ports

Icon
Connection to a Teradata Database Instance
Icon
The relation that contains input data.
Icon
The FitInputTable containing binning parameters for Variable-Width, not needed for EQUAL-WIDTH.

Output Ports

Icon
output of TD_BinCodeFit

Nodes

Extensions

Links