Optional Syntax Elements for TD_BinCodeFit - Teradata VantageCloud Lake

OUT clause

Accept the OutputTable clause for equal-width bins with generated labels.

OutputTable

[MethodType ('equal-width') only.] Specify a name for the secondary output table which contains the actual bins used by the TD_BinCodeTransform function.

LabelPrefix

[MethodType ('equal-width') only.] Specify either a prefix for all the target columns or a separate prefix for each of the target columns.

Lower Bin Boundary	Upper Bin Boundary	prefix-Generated Bin Label	prefix_count-Generated Bin Label
min	min + w	prefix_1	target_column_1
min + w	min + 2w	prefix_2	target_column_2
...	...	...	...
min + kw	min + (k - 1)w	prefix_k	target_column_k

Default: Target column name is used as the prefix

MinValueColumn

[MethodType ('variable-width') only.] Specify the name of the FitInput column that has the minimum value of the bin (lower bin boundaries).

Default: MinValue

MaxValueColumn

[MethodType ('variable-width') only.] Specify the name of the FitInput column that has the maximum value of the bin (upper bin boundaries).

Default: MaxValue

LabelColumn

[MethodType ('variable-width') only.] Specify the name of the FitInput column that has the bin labels.

Default: Label

TargetColNames

[MethodType ('variable-width') only.] Specify the name of the FitInput column that has the target column names.

Column range is not supported