Transpose Tables

../../../../../_images/pivot_table.svg
class node_pivot_table.TransposeTablesNew[source]

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.

Inputs:
input
: [table]

The Tables to transpose

Outputs:
output
: [table]

The transposed Tables

Configuration:
Column names as first column

Set column names from the input table as the first column in the transposed table

Use selected column as column names

Use the selected column from input table as column names in the transposed table, and discarding the selected column from the transpose.

Column names column

Column that contains the new column names