Use the Join action to combine content from two table
variables. This action enables you to combine content based on the shared values of a
specific column in the tables and store the content into a third Table variable or one of
the two source tables.
To join the content from two Table variables, do the following:
Procedure
-
Double-click or drag .
-
Select the first Table variable to use from the Enter first data
table name list.
-
Enter the name of the column from the first Table variable that contains the
data to join.
-
Select the second Table variable to use from the Enter second data
table name list.
-
Enter the name of the column from the second Table variable that contains the
data to join.
-
Select an option to specify the type of join. For more information, see Join type output examples.
-
inner join: Returns only the records that have
matching values in the selected columns in both tables.
-
left outer join: Returns all records from the
first table, and the matched records from the second table.
-
right outer join: Returns all records from the
second table, and the matched records from the first table.
-
full outer join: Returns all records when there
is a match in either left or right table.
-
In the Enter name of data table in which to join field,
select the table variable to store the combined values.
Note:
- Starting from Automation 360 v.27 if you are using
4.6.0-20220920-155212 version of the Data Table
package, the Enter name of data table in
which to join field is mandatory and you must
specify a third data table in the field to save the result of the
Join action.
- When you upgrade from a previous version to Automation 360, and if you have not updated the
package version to 4.6.0-20220920-155212, your bots
will continue to run as is. In case you have updated both your bots and the package to the latest
version, your bots will continue to run successfully
if you have selected a table variable to store the output. If the
field is empty, then the bot will encounter an
error.