Story line of Join Data Table

Dear innovator’s,

All we know that there is a Join Data table activity in UiPath.If we get any matching scenarios with unique value will approach join data table activity instead of filter/loop/array matching activity to find an exact match.

Join Data Table:
image

Combines rows from two tables by using values common to each other, according to a Join rule, which is specified in the Join Type property.

Sample Table:


INNER Join:

The INNER JOIN keyword selects records that have matching values in both tables.


LEFT Join:

The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2).

The result is NULL from the right side, if there is no match

FULL Join:

The FULL OUTER JOIN keyword returns all records when there is a match in left (table1) or right (table2) table records.

Regards,
Srenivasan Kannan

9 Likes

That something new i got to know :slight_smile:

Thanks

1 Like

Thank you for your contribution!

1 Like

Couple of viewers may get help from this video as well : Video Demo