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:
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