Difference between revisions of "Dataset Splitter"
(→Dataset Splitter) |
(→Dataset Splitter) |
||
(3 intermediate revisions by 3 users not shown) | |||
Line 3: | Line 3: | ||
The Dataset Splitter divides the current [[Data Table]] into sub-tables based on the values which appear in a specified column. For example, consider the following Data Table: | The Dataset Splitter divides the current [[Data Table]] into sub-tables based on the values which appear in a specified column. For example, consider the following Data Table: | ||
− | + | [[file:split_table_example.png]] | |
If we split the data over the "Group" column, this will divide the Table into four sub-tables, illustrated below: | If we split the data over the "Group" column, this will divide the Table into four sub-tables, illustrated below: | ||
− | + | [[file:split_example_group_a.png]] | |
− | + | [[file:split_example_group_b.png]] | |
− | + | [[file:split_example_group_c.png]] | |
− | + | [[file:split_example_group_d.png]] | |
− | What happens to these sub tables? Each one is passed to the next [[Task Element]] in a separate [[Execution Path]] so that it can be handled individually. For example it can be turned into an HTML Table, or used as the basis of subsequent queries, etc - see [[Iterative execution path|Iterative Execution Paths]]. | + | Notice that each sub-table now has a unique "Group". |
+ | |||
+ | What happens to these sub-tables? Each one is passed to the next [[Task Element]] in a separate [[Execution Path]] so that it can be handled individually. For example it can be turned into an HTML Table, or used as the basis of subsequent queries, etc - see [[Iterative execution path|Iterative Execution Paths]]. | ||
To join the sub tables back together into a single table use the [[Merge Data]] Node. | To join the sub tables back together into a single table use the [[Merge Data]] Node. | ||
+ | |||
+ | |||
+ | {{DataTableNodes}} |
Latest revision as of 12:52, 20 August 2015
Dataset Splitter
The Dataset Splitter divides the current Data Table into sub-tables based on the values which appear in a specified column. For example, consider the following Data Table:
If we split the data over the "Group" column, this will divide the Table into four sub-tables, illustrated below:
Notice that each sub-table now has a unique "Group".
What happens to these sub-tables? Each one is passed to the next Task Element in a separate Execution Path so that it can be handled individually. For example it can be turned into an HTML Table, or used as the basis of subsequent queries, etc - see Iterative Execution Paths.
To join the sub tables back together into a single table use the Merge Data Node.
Data Filter | Require Columns | Append Data Column | Multiple Column Appender
Drop Column | Drop Row(s) | Calculate Column Aggregate | Dataset Splitter | Merge Data
Create Data Table | Clear Data Table | Sort Data Table | Drop Duplicate Rows | Store Data Table | Retrieve Data Table
Task Elements > Data Table Nodes > Dataset Splitter