Using Join action

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

  1. Double-click or drag Data table > Join.
  2. Select the first Table variable to use from the Enter first data table name list.
  3. Enter the name of the column from the first Table variable that contains the data to join.
  4. Select the second Table variable to use from the Enter second data table name list.
  5. Enter the name of the column from the second Table variable that contains the data to join.
  6. 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.
  7. 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.