Merge Table
This activity is used to merge two table which have same structure.
Technical reference:
|
|
INPUT |
Table1: Specify the first datatable variable to merge with. |
|
Table2: Specify the second datatable variable to merge with. |
||
|
MISC |
Display Name: Displays the name of the activity. You can also customize the activity name to help troubleshoot issues faster. This name will be used for logging purposes. |
|
|
SkipOnError: It specifies whether to continue executing the workflow even if it throws an error. This supports only Boolean value “True or False.” True: Continues to execute the workflow irrespective of any error thrown. False: Stops the workflow if it throws any error |
||
|
Version: It specifies the version of the DataTable automation feature in use. |
||
|
OUTPUT |
Table: Declare and assign a variable to return the merged table as a separate table. This is not a mandatory field however declare a variable to view the merged table. |
* Mandatory fields to execute the workflow.
Example:
The following explains how to merge two tables of same structure. Here we are going to create a same table with other inputs and then merge it.
1. Create two tables one below the other with same structure and data using the generate table activity.
2. Declare and assign a variable in the output of both the generate table activities as “Test” and “Table_2” respectively.
3. Drag and drop the Merge table activity to the workflow.
4. Connect it to the second Generate table activity.
5. Enter the table variable “Test” in the Table 1 of the merge table properties panel.
6. Enter the table variable “Table_2” in the Table 2 of the merge table properties panel.
7. Declare and assign a variable as “Merged_Table” in the output of the merge table properties panel.
8. Add table viewer activity and connect it below the Merge table activity.
9. Enter the variable name “Merged_Table” as input and give a message title for the activity.
10. Now, execute the workflow.
The bot executes the workflow, merges both the table and gives the output as a single table.