En

Join Data Tables#

Join two Data Tables into one.

First Data Table[Data Table] The data table to which the second table will be joined.
Second Data Table[Data Table] The data table that will be joined to the first one.
Join Type

Select the type of table join if the schemas of the specified tables differ.

Possible options:

  • Add - adds the necessary columns to complete the schema;
  • Ignore - ignores additional columns;
  • Error - generates an error if the specified column mapping is missing;
  • AddWithKey - adds the necessary columns and primary key information to complete the schema;
  • AddRight - adds columns from the second table to the right of the columns from the first table.
Key Column[Text] The name of the column for the primary key. Used with the "AddWithKey" join type.
Result[Data Table] Returns the resulting 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 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" - 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 Message[Text] Returns detailed information about the error in case of incorrect execution of the block's work.