Dataset Splitter

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:

http://www.international-presence.com/wikidocs/images/split_table_example.png

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

http://www.international-presence.com/wikidocs/images/split_example_group_b.png

http://www.international-presence.com/wikidocs/images/split_example_group_c.png

http://www.international-presence.com/wikidocs/images/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.

To join the sub tables back together into a single table use the Merge Data Node.