I don’t care if the entire row matches, just if column X matches. Example: DT_1: Col_1 | Col_2 A 1 B 2 C 3 DT_2: Col_1 | Col_2 A 3 I’ll want to remove A From DT_1 because it exists in DT_2.

dt1.AsEnumerable().Except(dt2.AsEnumerable(), DataRowComparer.Default).CopyToDataTable; Handling empty result: :ambulance: :sos: [FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum

Best way to remove matching column values in two different data tables?

Help Studio

ppr (Peter Preuss) March 17, 2023, 5:26pm 7

dt1.AsEnumerable().Except(dt2.AsEnumerable(), DataRowComparer.Default).CopyToDataTable;

Handling empty result:
[FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum

1 Like

Topic		Replies	Views
Need to Compare Two datatable columns and remove the rows Studio studio , question , activities_panel	4	883	September 13, 2023
Remove duplicate rows from two datatables based on a specific columns Activities excel , linq	8	1540	August 31, 2022
How to match two data table depends on one columns and delete the row from second data table? Activities database , activities , question	3	285	June 10, 2023
Compare two different excel columns and matched remove data in second excel sheet Studio studio , question , project_panel	19	926	July 7, 2023
Remove rows that matches with another DT Studio studio , question , activities_panel	2	244	August 29, 2023

Most Active Users - Yesterday
ashokkarale
Yoichi
postwick
Anil_G
kishan.savaliya
Laura_Hubbard
Tselisehang_Molebatsi
Byrnecut
Lahiru.Fernando
wahyumrizqi
More details...

Best way to remove matching column values in two different data tables?

Related Topics