Many to One (PMML)

Transforms the values of multiple columns into a single column depending on the include method and documents the transformation in PMML. If set to binary the condensed column's value is set to the name of the first column with value 1. If the include method is maximum or minimum the value of the condensed column is set to the name of the column which, of all included columns, has the largest or smallest value. If the include method is binary and all columns are 0 the condensed column will contain a missing value.

Options

Columns

The columns to be condensed into a single column using the selected include method.

Condensed column name

The name of the appended column.

Include method

The method to condense multiple columns into one.
Binary: Name of first column with value 1
Maximum: Name of column with the largest value
Minimum: Name of column with the smallest value
Include Pattern: Name of first column that matches the given pattern (currently not supported in PMML, uses option Binary within the generated PMML document)

Include pattern

When include method is RegExPattern, this is the pattern used.

Keep original columns

Determines whether the included columns are kept or not.

Input Ports

Data

Output Ports

Data with transformed columns

Transformed PMML input

Best Friends (Incoming)

• Missing Value (12 %) 
• File Reader (8 %) Streamable
• Example Data (4 %) 
• CSV Reader (4 %) 
• Table Reader (4 %) Streamable
• Tree Ensemble Model Extract (4 %) 
• Auto-Binner (4 %) 
• Category To Number (Apply) (4 %) 
• Number To Category (Apply) (4 %) 
• String To Number (4 %) StreamableDeprecated
• Extract Column Header (4 %) 
• Many to One (4 %) 
• Row Filter (4 %) Streamable
• GroupBy (4 %) 
• Normalizer (4 %) 
• Partitioning (4 %) 
• Pivoting (4 %) 
• Column Filter (PMML) (4 %) Streamable
• One to Many (PMML) (4 %) 
• Number To String (PMML) (4 %) Deprecated
• Transpose (4 %) 
• Unpivoting (4 %) 
• Excel Reader (XLS) (4 %) Streamable
• Show all 23 recommendations

Best Friends (Outgoing)

• Joiner (50 %) 
• Column Filter (PMML) (50 %) Streamable

Installation

To use this node in KNIME, install KNIME Base Nodes from the following update site: