Sort Data Table

Sorts the data table.

Sorts an entire data table in ascending or descending order based on a specified column.

Input

• Input : DataTable Variable The DataTable variable to be sorted.

Sorting Column

• Column Index : Integer Argument The index of the column you want to sort by.

• Column Name : DynamicSearchString The name of the column you want to sort by.

  • Text - The full name of the column that is to be sorted.

  • Regex - The regex is used to find matching column names to be sorted.

  • Wildcard - The character that is used to search for matching column name. The asterisk (*)and the question mark (?) are used as wildcard characters. The asterisk represents zero or more characters in a string. The question mark represents any one character.

When multiple matches are found while using Search Methods, only the first match is considered.

The Text, Regex and Wildcard search methods are supported.EditDistance is not supported.

• Data Column : Object Argument The Data Column you want to sort by.

Only one sorting column argument can be set.

• Order :

  • Ascending - Sorts the data table by ascending order which means the first value is the lowest

  • Descending - Sorts the data table in descending order which means the first value is the highest.

Output

• Output : DataTable Variable Sorted Data Table result. Placing the same variable as the variable in the Input field changes the initial variable while adding new variables does not affect the initial variable.