VSplit Table¶
Vertical split of Table into Tables.
| Opposite node: | VJoin Table |
|---|---|
| Ref. nodes: | VSplit Tables |
Ports:
Inputs:
port1: table
Input Table
Outputs:
port1: [table]
Split Tables
Configuration:
- no_index
- 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.
- input_index
- Choose name for index column. All rows with the same value in this column will end up in the same output table.
- missing_index
- Choose name how to handle tables where the selected index column is missing.
- remove_fill
- After splitting, remove columns that contain only NaN or empty strings.
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.
