Lookup multiple values or multiple columns and get the result from the third column

[ppr (Peter Preuss)]

@kamal_hamad

Give a try on Join DataTable Activity

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: [image] INNER Join: The INNER JOIN keyword selects records that have m…

A demo here:
LeftJoin_3Cols_ResultWithMatch-1Col.xaml (12.7 KB)

As an alternate option we can do it with a LINQ Statement

• Join Approach
• Where / Any Approach

For some demo implementations have a look here:
FindMatches_1Col_fetchValues.xaml (10.1 KB)

we can easy extend to check it with 2 columns