0 ×

Many to One (PMML)

KNIME Base Nodes version 4.3.0.v202012031743 by KNIME AG, Zurich, Switzerland

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)

File Reader (10 %) Streamable
Table Reader (7 %) Streamable
One to Many (PMML) (6 %)
~~Excel Reader (XLS)~~ (6 %) StreamableDeprecated
Row Filter (6 %) Streamable
Show all 61 recommendations

Best Friends (Outgoing)

Normalizer (PMML) (14 %)
Many to One (PMML) (7 %)
~~Excel Writer (XLS)~~ (7 %) Deprecated
~~CSV Writer~~ (6 %) StreamableDeprecated
Column Filter (PMML) (3 %) Streamable
Show all 50 recommendations

Installation

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

KNIME 4.3

A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.