TD_​OrdinalEncodingFit

This function takes a input table partitioned by ANY and a optional category table in case of LIST approach as Dimension and generates integer ordinal values for unique category in each of the target columns.

Options

Approach

Specifies whether to determine categories automatically from the input table data (AUTO approach) or the user provided list (LIST approach).

Categories (strings seperated by new line)

Specifies the list of categories that need to be encoded in the desired order.

CategoriesColumn

Specify the CategoryTable column which contains the category values.

DefaultValue (integers seperated by new line)

Specify the ordinal value/values to use when category is not found. One value for all target column or multiple value for multiple target column.

OrdinalValues (integers seperated by new line)

Specifies custom ordinal values to replace the categories.

OrdinalValuesColumn

Specify the CategoryTable column which contains the ordinal values. If omitted, ordinal values will be generated based on the StartValue argument.

StartValue (integers seperated by new line)

Specify the starting value/values for ordinal values list. One value for all target column or multiple value for multiple target column.

Output Schema

Output Schema, if Volatile is true then use user login as the schema.

Output Table

Output Table

VAL Location

VAL Location

TargetColumn

Specify the categorical input target columns.

TargetColumnNames

Specify the CategoryTable column which contains the names of the target columns.

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.

Nodes

• String Configuration7 ×
• Column Filter Configuration4 ×
• Table Row to Variable4 ×
• Python Script2 ×
• Boolean Configuration1 ×
• Show all 14 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Database
• FeatureKNIME Quick Forms

Links

• No links available