How to match data between 3 columns

[Gokul001 (Gokul Balaji)]

Hi @Filipe_Silva

Refer this thread

Compare multiple columns in excel

@nabeelu About the Scenario and Approach: Sheet 1 = D1 Sheet 2 = D2 Definition of a Group: D1.ID Definition of a Match: In a Group D1.Value = D2.Value Group D1 Data Process every Group one by one - D1Stack Retrieve from D2 all items having the same Group Key - D2 Stack Find the matches between D1Stack And D2 Stack - Matches Remove Matches D1Matches from D1Stack, Similar doing it with D2 take from D2Stack items of the count of remaining elements in D1Stack or less if D2Stack.Count < D1Stac…

Datatable comparison using multiple columns

Hi @John_Dara Following the attached workflow created using the Linq queries with minimal activities. Used the received and sent excel attached by you in your question Used Join datatable with full outer join to join receive and sent files Used the following linq query to update the both amount_remarks and name_remarks at a shot (From d In dtNewBuild.AsEnumerable Let amount_remarks = If( CDbl(d(“Amount_Sent”))=0, “Amount not sent”, If(CDbl(d(“Amount_Credited”))=0, “Amount not credited”, If…

If possible can you share the Sample input excel file and output

Regards
Gokul