MergeTable

This activity helps the user to merge “Two datatables” which have similar data structure into one table.

Properties

INPUT

MissingSchemaAction:* It indicates the “Action” to perform while merging the “datatables”. Choose the options from the drop down,
Add: It enables to merge all the details in both the tables irrespective of the number of columns present.  
Error: It enables to merge the details in both the tables but if there is an error in any of the tables it throws an exception here. 
Ignore: It enables to ignore all other details which is not common in between the “datatables” and displays only the common data available in both tables. 
Addwithkey: It enables to merge the table in accordance with the “Primary key” that is validated.
If a row that has common values in both tables, this schema action will ignore the row to avoid duplicates. 
If the rows are not common between both tables, the entire “Source datatable” will be added to the “Destination datatable”.

Table1:*  Indicates the “Source datatable”. Enter the “Input datatable” variable where the input data is stored.
This parameter helps you to merge with “datatable2”.
This field only accepts the “datatable” data type.

Table2:* Indicates the “Destination datatable”. Enter the “Input datatable” variable where the input data is stored.
This parameter helps you to merge with “datatable1”.
This field only accepts the “datatable” data type.

MISC

DisplayName: Displays the name of the activity. It can also customize the activity name to helps in troubleshooting.

SkipOnError: It specifies whether to continue executing the workflow even if it throws an error. This supports only Boolean value “True or False”. By default, it is set to “False.”
True: Continues the workflow to the next step.
False: The workflow aborts if it throws any error.
None: If the option is specified as blank, by default the activity will perform as “False” action.
Version: It specifies the version of the Datatable automation feature in use.

OUTPUT

Table: It to view the output of the activity as the “Merged” table in a “Datatable” datatype.

Result: It helps to view the execution state of the activity. It returns the values in Boolean format.

* Represents mandatory fields to execute the workflow.