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 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.
Note: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.
The Mappings panel allows users to specify which columns in a worksheet are involved in the worksheet transformation. Required input is highlighted orange in the interface.
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 Split Worksheet object also creates one text file.
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 worksheet used and the options selected.
