Sort#

Sort the Data Table in the specified direction.

Table[Data Table] The data table to be sorted.
Index or column name[Number/Text] The index or name of the column to be sorted.
Direction

Sorting direction:

  • ASC - ascending/alphabetical,
  • DESC - descending/reverse alphabetical.
Sort type

Select the type of sorting.

Possible values:

  • Default - default sorting based on the column type;
  • LeftPadding - sorting rows with left padding spaces;
  • NumbersLikeStrings - sorting strings as numbers;
  • DatesLikeStrings - sorting strings as date and time.
Date format[String] The date format when sorting. This property is used only if the sort type "DatesLikeStrings" is enabled.
Result[Data Table] Returns the sorted table.
Error handling level

Select the error handling level. Possible values:

  • "Default" - default;
  • "Ignore" - errors are ignored;
  • "Handle" - errors are handled.

If "Default" is selected, the value of the "Start" block of this diagram will be used.

Message level

Select the message level that blocks will output during operation. Possible values:

  • "Default" - default;
  • "Release" - output is disabled;
  • "Debug" - main information output;
  • "Detailed" - detailed information output.

If "Default" is selected, the value of the "Start" block of this diagram will be used.

Error message[Text] Returns detailed information about the error in case of incorrect execution of the block's work.