Compare three columns in two excel and update the main excel

[ppr (Peter Preuss)]

have a check on a join datatable approach

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…

using a LINQ or Join Datatable Activity for it

@kavya.s16

if they are same update the main excel with a column value in output excel

unfortunately it is not describing which value is to use for the update

In other cases we can also use a LINQ for checking / retrieving the match in dt2.

The best would be you can share some sample data along with the expected output description. based on this we will workout a solution suggestion more individually to your case.