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:

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. Select the table variable to store the combined values from the Enter name of data table in which to join list.
8. In the Assign value to variable list, select a string variable.