Comparing two separate Excel files and keeping only unique results

[ppr (Peter Preuss)]

when we join the two datatables with Join type FULL we can detect in the join result

• matching items - left join col AND right join col are not null (and the same)
• not matching in right table - left join col is not null and right join col is null
• not matching in left table - left join col is null and right join col is not null

Well explained also here

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…