Icon

Table Manipulator

The Table Manipulator is one of the most versatile nodes in KNIME. Its functionality is similar to the Column Filter, Column Resorter, Colume Rename, various conversion node (e.g., String to Number), and Concatenate--all in one.

Although the Table Manipulator offers multiple uses, it is not always a better choice than using, say, a Column Filter and a Column Resorter. That is because the Table Manipulator is much less dynamic; there is no way, for example, to include columns based on a wildcard expression.

The Transformations pane allows you to select fields, order them however you wish, change their names, and change their data type. The Reset Actions button reveals a menu that allows you to reset any or all of the actions you have performed.

Finally, the Table Manipulator also lets you concatenate (that is, union) two or more tables. To do this, you must first press the small ellipses button (three dots) in the lower-left corner of the node icon. Pressing "Add Input Port" will add a new table input. You may add as many of these as you wish.

If you combine multiple tables in this way, you can control which columns are included through the Take Columns From: Union/Intersection option.
- Union: All columns from all tables are included in the output
- Intersection: Only columns that exist in each table are included in the output

Table Manipulator The Table Manipulator is one of the most versatile nodes in KNIME. Its functionality issimilar to the Column Filter, Column Resorter, Colume Rename, various conversionnode (e.g., String to Number), and Concatenate--all in one.Although the Table Manipulator offers multiple uses, it is not always a better choicethan using, say, a Column Filter and a Column Resorter. That is because the TableManipulator is much less dynamic; there is no way, for example, to include columnsbased on a wildcard expression.The Transformations pane allows you to select fields, order them however you wish,change their names, and change their data type. The Reset Actions button reveals amenu that allows you to reset any or all of the actions you have performed.Finally, the Table Manipulator also lets you concatenate (that is, union) two or moretables. To do this, you must first press the small ellipses button (three dots) in thelower-left corner of the node icon. Pressing "Add Input Port" will add a new table input.You may add as many of these as you wish.If you combine multiple tables in this way, you can control which columns are includedthrough the Take Columns From: Union/Intersection option.- Union: All columns from all tables are included in the output- Intersection: Only columns that exist in each table are included in the output The Table Manipulator can deselect fields, includingthe dynamic placeholder <any unknown newcolumns>. In this example, no new columns will beselected if they appear in the table. Night Heron Data, 2023 Fields were reordered, deselected, and renamed.Notice that the Preview pane shows the changes youmake in real time. Concatenate two tables and show only theintersection (that is, common to each table) columns.Notice how the records from the second table arelisted below those of the first table. Input some dataDeselect fieldsMultiple transformationsConcatenate, takeintersection ofcolumnsInput some data Table Creator Table Manipulator Table Manipulator Table Manipulator Table Creator Table Manipulator The Table Manipulator is one of the most versatile nodes in KNIME. Its functionality issimilar to the Column Filter, Column Resorter, Colume Rename, various conversionnode (e.g., String to Number), and Concatenate--all in one.Although the Table Manipulator offers multiple uses, it is not always a better choicethan using, say, a Column Filter and a Column Resorter. That is because the TableManipulator is much less dynamic; there is no way, for example, to include columnsbased on a wildcard expression.The Transformations pane allows you to select fields, order them however you wish,change their names, and change their data type. The Reset Actions button reveals amenu that allows you to reset any or all of the actions you have performed.Finally, the Table Manipulator also lets you concatenate (that is, union) two or moretables. To do this, you must first press the small ellipses button (three dots) in thelower-left corner of the node icon. Pressing "Add Input Port" will add a new table input.You may add as many of these as you wish.If you combine multiple tables in this way, you can control which columns are includedthrough the Take Columns From: Union/Intersection option.- Union: All columns from all tables are included in the output- Intersection: Only columns that exist in each table are included in the output The Table Manipulator can deselect fields, includingthe dynamic placeholder <any unknown newcolumns>. In this example, no new columns will beselected if they appear in the table. Night Heron Data, 2023 Fields were reordered, deselected, and renamed.Notice that the Preview pane shows the changes youmake in real time. Concatenate two tables and show only theintersection (that is, common to each table) columns.Notice how the records from the second table arelisted below those of the first table. Input some dataDeselect fieldsMultiple transformationsConcatenate, takeintersection ofcolumnsInput some data Table Creator Table Manipulator Table Manipulator Table Manipulator Table Creator

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: johnemery
Created at: 2023-05-19
On NodePit since: 2023-05-21
Last update: 2024-05-02
Created with KNIME version: v4.7.2
Tags: table manipulatornode bitesnight heron data

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!