Hub
NodeNode / Manipulator

Table Manipulator

Manipulation Column Streamable
Drag & drop
Like
Copy short link

Allows to perform several column transformations on any number of input tables such as renaming, filtering, re-ordering and type changing of the input columns.

If more than one input table is available the node concatenates all input rows into a single result table. If the input tables contain the same row ID the node can either generate a new row ID or prepend the input table index to the original row ID of the corresponding input table.

Node details

Input ports
  1. Type: Table
    Table 0
    Table to manipulate
Output ports
  1. Type: Table
    Appended table
    A table with the transformed columns from all input tables (Table 0, Table 1, Table ...)
input (Dynamic Inport)
Table(s) contributing subsequent rows and columns.
  1. Type: Table

Extension

The Table Manipulator node is part of this extension:

Related workflows & nodes

  1. Table Manipulator Example
    data_coach > KNIME Foundations > 3 - Manipulating Data > 2 - Table Manipulator > Table Manipulator Example
  2. Manipulate several columns at once
    Life Sciences Table manipulation
    This workflow snippet demonstrates the usage of the Table Manipulator node. With the Tabl…
    knime > Workflow Snippets > Manipulate several columns at once
  3. Unpivoting - fredrikt
    elsamuel > Public > Unpivoting - fredirkt > Unpivoting - fredrikt
  4. Rule Engine Example
    data_coach > KNIME Foundations > 5 - Calculations and Aggregating Data > 4 - Rule Engine > Rule Engine Example
  5. Table Manipulator Revisited Example
    data_coach > KNIME Foundations > 4 - Field Types and Conversions > 2 - Table Manipulator Revisited > Table Manipulator Revisited Example
  6. Column Expressions Example
    data_coach > KNIME Foundations > 5 - Calculations and Aggregating Data > 5 - Column Expressions > Column Expressions Example
  7. 2 - String Manipulation Example
    data_coach > KNIME Foundations > 5 - Calculations and Aggregating Data > 2 - String Manipulation > 2 - String Manipulation Example
  8. justknimeit-4
    #justknimeit-4
    Solution to the justknimeit-4 challenge
    christian_essen > Public > justknimeit-4
  9. Split Cells and Create New Rows
    kathrin > Forum Questions > Split Cells and Create New Rows
  10. KN CH 04
    adrix > Public > KNM CH 04