Difference between revisions of "Dataset Splitter"

From PresenceWiki
Jump to: navigation, search
(Dataset Splitter)
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:
  
http://www.international-presence.com/wikidocs/images/split_table_example.png
+
[[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:
  
http://www.international-presence.com/wikidocs/images/split_example_group_a.png
+
[[file:split_example_group_a.png]]
  
http://www.international-presence.com/wikidocs/images/split_example_group_b.png
+
[[file:split_example_group_b.png]]
  
http://www.international-presence.com/wikidocs/images/split_example_group_c.png
+
[[split_example_group_c.png]]
  
http://www.international-presence.com/wikidocs/images/split_example_group_d.png
+
[[file:split_example_group_d.png]]
  
 
Notice that each sub-table now has a unique "Group".
 
Notice that each sub-table now has a unique "Group".

Revision as of 08:51, 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:

Split table example.png

If we split the data over the "Group" column, this will divide the Table into four sub-tables, illustrated below:

Split example group a.png

Split example group b.png

split_example_group_c.png

Split example group d.png

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