Difference between revisions of "Dataset Splitter"

Revision as of 16:48, 22 June 2010

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 - see Iterative Execution Paths.

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