Automation Anywhere | Return Type of Join Command

 RPA | Join Command A2019 Automation Anywhere| Automation Anywhere - Part-18

Join Command | The join command is basically used to combine "data from two table variables and store the output into the third table variable". Through this command the data from two table variables are combined and are stored into the third table variable and the return type that this command returns is the table variable. This command is present under the Data Table command in Automation Anywhere A2019.

To use the Join command follow the steps as described below:-

1. Drag and drop the Join command from the Data Table command.
2. Enter the first data table name.
3. Enter the column name from the first table which contains the data that needs to be joined.
4. Now enter the second data table name.
5. Enter the column name from the second table which contains the data that needs to be joined with the first data table column name.
6. Now we need to specify the type of join. We have 4 types of join i.e. inner join, left outer join, right outer join and full outer join.

Now we will discuss the different types of join we can use in detail step by step as follows:-

• Inner Join - Inner join will return records that contains matching values in both the tables.

Following diagram represents the inner join as shown below:-

• Left Outer Join - Left outer join will return records from the first table and the matching records from the second table.

Following diagram represents the Left Outer join as shown below:-

• Right Outer Join - Right outer join will return records from the second table and the matching records from the first table.

Following diagram represents the Right Outer join as shown below:-

• Full Outer Join - Full outer join returns all records when there is a match in either left or right table.

Following diagram represents the Full Outer join as shown below:-

So that's all about the Join command and what return type we will be getting when we will be using Join command using Data Table command.

If you have any queries regarding Join command please feel free to raise your queries and I will be more than happy to resolve all your queries.