Transpose Table

../../../../../_images/pivot_table.svg

This node performs a standard transpose of tables. Bear in mind, since a column can only contain one type, if the rows contain different types the transposed columns will be converted to the closest matching type. The worst case is therefore strings.

An exception to this behaviour is when the first column contains strings. Using the option ‘Use selected column as column names’ the selected column will replace the column names in the new table. The rest of the input table will be transposed, discarding the name column.

The other option is ‘Column names as first column’ which will take the table’s column names and put them in the first column in the output table. This is convenient if you simply want to extract column names from a table.

Ports:

Inputs:

input:

table

The Table to transpose

Outputs:

output:

table

The transposed Table

Configuration:

use_col_names
Set column names from the input table as the first column in the transposed table
reverse_col_names
Use the selected column from input table as column names in the transposed table, and discarding the selected column from the transpose.
columns
Column that contains the new column names
class node_pivot_table.TransposeTableNew[source]