Split a worksheet based on the data types that are mapped to the Sort context. The worksheet is divided into separate worksheets based on the sort key. For example, if a column named Subject ID is mapped to Sort, then a worksheet for each subject ID is created in the output.
Use one of the following to add the worksheet object to a Workflow:
Right-click menu for a Workflow object: New > Data Management > Split Worksheet.
Main menu: Insert > Data Management > Split Worksheet.
Right-click menu for a worksheet: Send To > Data Management > Split Worksheet.
To view the object in its own window, select it in the Object Browser and double-click it or press ENTER. All instructions for setting up and execution are the same whether the object is viewed in its own window or in Phoenix view.
Mappings panels identify how input variables are to be used. Map the data by dragging the dataset from the Data folder to the Setup tab or use the 
icon in the Setup tab.
Once a dataset is mapped, use the option buttons in the Mappings panels to assign the columns in the dataset to the appropriate context associations. Required context mappings are colored orange.
Sort: Data types to use for creating the separate output worksheets.
Ignore: Data types to exclude from any output worksheets.
Check the Create Worksheets Split by Sort Values box (the default) to create a separate worksheet for each data type mapped to Sort, along with the Unique Values worksheet (which lists the number of occurrences of each Sort).
If this box is unchecked, then only the Unique Values worksheet is created in the output.
The number of worksheets the Split Worksheet object creates is based on the number of unique values in the data types mapped to the Sort context. The worksheet names are derived from the values in the data types mapped to Sort.
The Unique Values worksheet is always created. The Unique Values worksheet lists the number of times a sort key or keys are present in the input worksheet. For example, if Time is mapped to Sort, and there are 10 time values per profile, then each time value is listed in one column, and the total instances of each time value is listed in the Count column.
The object generates the following:
Separate worksheets: The values of each data type mapped to Sort, along with the associated values in the worksheet for each unique sort profile.
Unique Values: Lists the number of times a sort key(s) are present in the input worksheet.
Settings: Text file containing input worksheets used and the options selected.