JoinDatatable

This activity can be used to join two tables with similar data columns from the input tables.

Properties

INPUT

DataTable1: *Specify the “datatable” variable where the input data is stored. This parameter helps you to provide the first “datatable” to join the values. This field accepts only “Datatable” datatype.

DataTable2: *Specify the “datatable” variable where the input data is stored. This parameter helps you to provide the second “datatable” to join the values. This field accepts only “Datatable” datatype.

JoinType:* Choose options from the dropdown to select the join type.
Full: Joins all rows from two tables regardless of whether the specified condition is met. Null values are added if data is not available in the datatable.
Left: Joins values meeting the condition from the second datatable. Null values are added to “Datatable1” if no values match the rows from “Datatable2”.
Inner: Joins all values from both tables and removes rows that don’t meet the condition. (For more details, refer to the document below.)

MISC

DisplayName: Displays the name of the activity. The activity name can also be customized to help 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

DataTable:* It helps to view the output of the activity after joining the rows in a “Datatable” datatype. (Refer the steps below to create a variable).

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.