Assigning Data to Roles

To run the Sort Data task, you must assign an input data source. To filter the input data source, click Filter Icon

You must assign a column to the Sort by role.

Role	Description
Sort by	When you assign one or more variables to this role, the table is grouped by the selected variable or variables. The order in which the variables appear within this role determines which variable is the primary sort key, which variable is the secondary sort key, and so on. The primary sort key is always the first variable that is listed within the Sort by role.
Columns to drop	When you assign one or more variables to this role, the output that is generated does not contain the specified variables. You can assign a maximum of (n – 1) variables to this role, where n is the total number of variables in the table.