Create a new column in an output worksheet by ranking columns in the source worksheet in ascending or descending order and sorting them based on the Group By selections.
Use one of the following to add the object to a Workflow:
Right-click menu for a Workflow object: New > Data Management > Rank Worksheet.
Main menu: Insert > Data Management > Rank Worksheet.
Right-click menu for a worksheet: Send To > Data Management > Rank 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.
Group By: Phoenix generates a separate set of ranking values for each unique value or group of values in columns mapped to the Group By context.
Rank: Parameters or variables mapped to Rank are ranked in ascending or descending order.
Any study variable or parameter mapped to the Group By context acts as a sort key in the output worksheet. If enough data types are mapped to Group By to create individual profiles for each rank, then the ranking column values never go above one.
Data types mapped to Rank are ranked either numerically or alphabetically, depending on the data contained in the column.
If there are no matching values in a column mapped to the Rank context, and one or no columns are mapped to Group By, then the ranking count is incremented by one.
For every matching value in any column mapped to the Rank context, the ranking count is incremented by 0.5 for every N+1 matching values. For example, if the ranked column starts with two matching values, then the ranking for the first two values is 1.5 and 1.5. If the ranked column starts with three matching values the ranking is 2, 2, and 2. If there are four the ranking is 2.5, 2.5, 2.5, and 2.5.
When matching values are encountered, the normal incrementation by one is stopped, the matching values are given equal ranking numbers, and the incrementation resumes normally with the next non-matching value.
-
In the New Column Name field, type a name for the ranking column.
The ranking column ranks the data types mapped to Rank in incremental order based on how many unique values are in the ranked data. -
In the Sort Direction menu, select an ascending or descending sort direction for the rank column.
The Rank Worksheet object generates one worksheet and one text file. The output worksheet is arranged alphabetically or numerically based on the first selected sort key.
Ranked: The ranked values, in ascending or descending order.
Settings: Text file containing input worksheet used and the options selected.
