# 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.
--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.sherparpa.ru/en/sherpa-rpa/sherpa-designer/spravochnik-blokov/tablicy-dannykh-datatable/soedinit-tablicy-dannykh-mergedatatable.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.