VSplit Table

The operation of vertical split, or VSplit, performs a rowwise split of Tables.

If an index column is specified in the configuration GUI the split will be performed according to defined groups in this column. Otherwise the node will place every row of the incoming Table into separate Tables in the outgoing list.

In the index column the elements of the rows, that belong to the same group, should all have the same value. An example of an index column is created by the VJoin Table node, where the elements in the joined output that originates from the same incoming Table will be given the same index number.

If “One table for each row” is used, the selected index is ignored and the split is performed as if each row had their own distinct index value. Otherwise, for tables where the selected index column is missing, “Action on missing Index” controls the behavior.

Yet another available option in the node is to remove columns that after the split contain only NaNs or empty strings. This is called “Remove complement columns” in the configuration GUI and is (loosly speaking) the reversal of the creation of complements for missing columns preformed by the VJoin Table node.

class node_vsplit_tables.VSplitTableNode

Vertical split of Table into Tables.

Opposite node:

VJoin Table

Ref. nodes:

VSplit Tables

Inputs:

port1 : table

Input Table

Outputs:

port1 : [table]

Split Tables

Configuration:

One table for each row.

If checked, each row in the input table will be put in a different table in the output. If unchecked, you need to specify an index column which will then be used to determine what rows go in which table.

Index column

Choose name for index column. All rows with the same value in this column will end up in the same output table.

Action on missing index

Choose name how to handle tables where the selected index column is missing.

Remove complement columns

After splitting, remove columns that contain only NaN or empty strings.