The following node is available in the Open Source KNIME predictive analytics and data mining platform version 2.7.1. Discover over 1000 other nodes, as well as enterprise functionality at
http://knime.com.
Column Combiner
Combines the content of a set of columns and appends the concatenated string
as separate column to the input table. The user needs to specify in the dialog
the columns of interest and some other properties, such as delimiter to separate
the different cell contents and quoting options.
Dialog Options
- Delimiter
- Enter a delimiter string here. This string is used to separate
the different cell contents in the new, appended column.
- Quote Character
- The character entered here will be used to quote the cell content
in case that it contains the delimiter string (for instance if the cell content is
some;value, the delimiter string is ';' (a single semicolon), and the quote character is '"'
(single quote char) the quoted string will be "some;value"
(including quotes)). You can force quotation by checking "Quote Always".
Alternatively, the user can also replace the delimiter string in the cell content string (see below).
- Replace Delimiter by
- If the string representation of the cell content contains the
delimiter string, it will be replaced by the string entered here (if you entered '-' here, the output of
the above example would be some-value).
- Name of appended column
- The name of the new column.
- Column Selection
- Move the columns of interest into the "Include" list.
Ports
Output Ports
0 |
Input data + additional column containing string combination |
This node is contained in KNIME Base Nodes
provided by KNIME GmbH, Konstanz, Germany.