Sort action

The Sort action in the Data Table package enables you to sort the values within the column of a specific data table in either ascending or descending order.

Settings

The column data format available for the data table is string, number, datetime, or boolean.

  • In the Enter datatable name field, enter the name of the table in which you want to sort the column values.

    (Optional) If there is no data table available, you can create one. Click the Create variable icon.

    After you have created a data table variable, select it in the Enter datatable name field.

  • Use the Sort by column field to select one of the following options:
    • name - To specify the name of the column and sort the values within it.

      (Optional) Click the Insert a value icon to select an existing variable that contains the column name.

    • index - To specify the column index.

      (Optional) Click the Insert a value icon to select an existing variable that contains the table index.

      Index numbers start from 0. For example, if you have a data table that contains four columns and you want sort the values in the third column, enter 2 in the index field.

    Note: You can only sort the values within one column at a time. In order to sort the values across multiple columns of a data table, you must use the Sort action multiple times.
  • Click the Select the order in which to sort drop-down menu to select one of the following methods of sorting the column values:
    • ascending order
    • descending order
Note: If you built a bot using this action from package version 2.0.0-20200624-042148 or earlier, the action will be missing when you open the bot with the default package version. You must reinsert the action and repopulate the fields.