How to compare Datatables with values

[ppr (Peter Preuss)]

@smritijoshi
welcome to the forum

It can be handled as a full join case

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…

Join cols: User (optional additional Join Cols)
Join Type; Full Join

Then based on the Join Cols we can detect User Addtions /Removals (col is null)
The roles we can split row(“Role”).Split(","c).Select(Function (x) x.Trim).ToArray
The split Arrays we can anaylse with the Intersect and Except Operators

[HowTo] - Exploring the LINQ Universe (VB.Net)

LINQ (Language-Integrated Query) is part of the .NET framework and offers capabilities for interacting with data, objects, or other sources within a particular syntax. This HowTo elaborates on the availability of LINQ and explores the offered functionalities Current Version of this topic is DRAFT and will be finalized / enhanced soon Introduction Let’s recap the Example of LINQ from [HowTo] - First Start with LINQ (VB.Net). Sample data: myNumbers | List (Of Int32) = {12,34,5,8,10,2,15,7}.to…

Let us know your further open questions once YOu have started to explore a Full Join with the Join DataTAble Activity