JoinDatatable

Estimated reading: 3 minutes

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.

Utilization of Join Table Wizard:
1. Double click on the activity and provide the input datatable for “Datatable1”.
2. Specify the input datatable for “Datatable2”.
3. Click on the three lines adjacent to the “DataTable1” and choose the “Edit wizard” option
4. The wizard contains three sections-
a. To provide “Input” datatables and choose the “Join Type.”
b. To provide the “Output” datatable to view the joined table.
c. To specify the “Condition” that needs to be met while joining the tables.
5. In the condition section, you need to start “=” operation as default.
a. The following are the conditions that are available,
<: It validates to check whether the provided “ColumnName” is lesser than the specified “ColumnName” in the DataTable2.
>: It validates to check whether the provided “ColumnName” is greater than the specified “ColumnName” in the DataTable2.
<=: It validates to check whether the provided “ColumnName” is lesser than or equal to the specified “ColumnName” in the DataTable2.
>=: It validates to check whether the provided “ColumnName” is greater than or equal to the specified “ColumnName” in the DataTable2.
=: It validates to check whether the provided “ColumnName” is equal to the specified “ColumnName” in the DataTable2.
6. Specify the “Output datatable” variable and click on “Save”.

JoinDatatable

Properties

JoinDatatable

CONTENTS