Table Processing#

The block allows you to remove duplicate rows and select only specified columns.

Table[Data Table] The data table that needs to be sorted.
Remove duplicate rowsWhen enabled, the returned table will contain rows with different values for all columns.
Return columns

[Text/List] A string containing the names or indices of the columns. The separator is a comma.

A list of column names that should be included in the returned Data Table object. The Data Table object containing the specified columns in the order they appear within the array.

Result[Data Table] A table is returned that contains the requested rows and columns.
Error handling level

Select the error handling level. Possible values:

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

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

Message level

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

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

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

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