Optional Syntax Elements for TD_BinCodeFit - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢
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