Icon

Transpose

Unlike many other nodes which have configuration menus with many settings to understand, the Transpose node is very simple.

The Transpose node performs one operation: it turns table rows into columns and table columns into rows. For example, if you have a table with 50 rows and 20 columns, the Transpose node will output a table with 20 rows and 50 columns.

The only configuration menu setting is related to the "chunk size," which simply controls how much memory is used to perform the transpose operation. You do not need to play with this setting at all--the Tranpose node is completely "plug-and-play."

When you transpose a table, the RowID values will become column headers and the former column headers will become the new RowID values.

Transpose Unlike many other nodes which have configuration menus with many settings tounderstand, the Transpose node is very simple. The Transpose node performs one operation: it turns table rows into columns and tablecolumns into rows. For example, if you have a table with 50 rows and 20 columns, theTranspose node will output a table with 20 rows and 50 columns.The only configuration menu setting is related to the "chunk size," which simplycontrols how much memory is used to perform the transpose operation. You do notneed to play with this setting at all--the Tranpose node is completely "plug-and-play."When you transpose a table, the RowID values will become column headers and theformer column headers will become the new RowID values. Our original 6 row-by-63 column table now has 63rows and 6 columns, Note how the row ID andcolumn header values also swap places. Night Heron Data, 2023 Input some data Table Creator Transpose Transpose Unlike many other nodes which have configuration menus with many settings tounderstand, the Transpose node is very simple. The Transpose node performs one operation: it turns table rows into columns and tablecolumns into rows. For example, if you have a table with 50 rows and 20 columns, theTranspose node will output a table with 20 rows and 50 columns.The only configuration menu setting is related to the "chunk size," which simplycontrols how much memory is used to perform the transpose operation. You do notneed to play with this setting at all--the Tranpose node is completely "plug-and-play."When you transpose a table, the RowID values will become column headers and theformer column headers will become the new RowID values. Our original 6 row-by-63 column table now has 63rows and 6 columns, Note how the row ID andcolumn header values also swap places. Night Heron Data, 2023 Input some data Table Creator Transpose

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-25
On NodePit since: 2023-05-25
Last update: 2024-11-21
Created with KNIME version: v4.7.2
Tags: transposenode 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!