Sort

This activity helps the user to sort the column’s value in the table either in ascending or descending order.

Properties

INPUT

Column Name: *Enter the “Column name” to sort from the “Input datatable. “Provide the column name within double quotes or input the variable in “string” datatype where the column name is stored.
This field only accepts data in “String” datatype.

SortAs:* This option determines the sorting order for the “Columns.” Choose the order from the dropdown:
Ascending: Sorts in ascending order from smallest to largest or A to Z based on values.
Descending: Sorts in descending order from largest to smallest or Z to A based on values.

Table:*  Enter the “Input datatable” variable where the input data is stored this parameter helps you to sort the “Column” from the “datatable”.
This field only accepts the “datatable” data type.

MISC

DisplayName: Displays the name of the activity. The activity name can also be customized to help in troubleshooting.

SkipOnError: It specifies whether to continue executing the workflow even if it throws an error. This supports only Boolean value “True or False”. By default, it is set to “False.”
True: Continues the workflow to the next step.
False: The workflow aborts if it throws any error.
None: If the option is specified as blank, by default the activity will perform as “False” action.
Version: It specifies the version of the Datatable automation feature in use.

OUTPUT

Result: It helps to view the execution state of the activity. It returns the values in Boolean format.
True: It indicates the activity has been executed successfully without any error.
False: It indicates that the activity has been faulted due to some unexceptional error thrown.

SortDt:*  It helps to view the output of the activity as the “Sorted” columns in a “Datatable” datatype. (Refer the steps below to create a variable).

* Represents mandatory fields to execute the workflow.