Merge Data Table

Merges the data tables.

Merges the source data table with the destination data table based on merge type.

Input

• Source : DataTable Variable The Data Table object is to be added to the destination Data Table.
• Destination : DataTable Variable The DataTable variable to which the source DataTable is merged.
• Merge Type :

  • Add - Adds the necessary columns to complete the schema. It adds the extra columns in the destination table from the source and mapping the data from source to destination table.

  • Ignore - Ignores the extra columns. It does not add extra columns from the source. The mapping only happens if the source table contains similar columns otherwise destination table only contains its own data.

  • Error - An InvalidOperationException is generated if the specified column mapping is missing. It shows an error if the source table contains any extra columns otherwise it maps the data from the source to the destination table.

  • AddWithKey - Adds the necessary columns and primary key information to complete the schema. It adds the extra columns and primary key information in the destination table from the source and mapping the data from source to destination table.