"Merge Data Table" activity

Activity program nameAbout the "Merge Data Table" Activity

The "Merge Data Table" activity allows merging two data tables. Below is an explanation of its features and usage.

TABLE OF CONTENTS

• Activity program name
• Description
• Properties
• Usage (when column definitions are the same)
• Usage (when column definitions differ)

1. Activity program name

RCA.Activities.Core.MergeDataTable

2. Description

• For Studio version up to 2.0.2.0:
  Quick access: Toolbox > Data Table > Merge Data Table

• For Studio version 2.0.3.0 and later:
  Quick access: Toolbox > Core > Data Table > Merge Data Table

This activity is used to merge two data tables.

• Verified working version: 2.2.0.2

Note: Some labels and behavior may differ depending on the version.

3. Properties

4. Usage (when column definitions are the same)

If the two data tables to be merged have the same column definitions, the source table’s data is appended to the destination table.

Example:

Create a data table using the Build Data Table activity, e.g., rateTable.

Add a second data table, e.g., addRateData, with the same column definitions.

Drag and drop the Merge Data Table activity into the designer panel.

In the properties, assign:

• Source: addRateData (the table to be added).

• Destination: rateTable (the table to which data will be added).

Run the process. Data from addRateData is appended to rateTable.

To verify the output of the merged data table:

• Use the Output Data Table activity to convert the data table to a string.

• Display the string in the output panel using the Write Line activity, or show it in a message box by iterating through rows using the For Each Row activity.

In the example: The merged content will appear in the rateTable variable, which combines the original rateTable data with the data from the source table addRateData.

5. Usage (when column definitions differ)

If the column definitions of the two data tables differ, the result of the merge depends on the Action when schema is missing property.

Examples:

1. Destination Table:

2. Source Table:

When the property value is "Add":

• Includes all columns from both tables.

• Missing values are filled with default values (if defined) or Null.

When the property value is "Ignore":

• Ignores columns that exist only in the source table.

When the property value is "Error":

• Throws an error if column definitions differ.

• No data is merged in this case.