How to Get the uncommon row from DT1

[Tharusha.fernando]

i m having DT1 and DT2 i need to compare with DT1 if their is a new row other that DT2 data table i need to get that as the output

i used this but not getting correctly

ExtractDataTable.AsEnumerable().Except(updatedDatatable.AsEnumerable(),System.Data.DataRowComparer.Default).copydatatable

[ganesh4 (Ganesh)]

Use join data tables activity

Join Data Tables

[Tharusha.fernando]

hi @ganesh4
is join type left

[ermanoj3101 (MANOJ)]

Hi @Tharusha.fernando ,

Use below expression.

dt1.AsEnumerable().Where(Function(row) NOT dt2.AsEnumerable().Any(Function(x) x(“name”).ToString=row(“name”).ToString)).CopyToDatatable

Let me know if you face any issue.

[ermanoj3101 (MANOJ)]

You can also refer below process files.
It have both code to get matched and unmatched data.
LinqLeftAndRightJoin.zip (16.5 KB)

[Tharusha.fernando]

hi @ermanoj3101
if i need to compare both “Name” and “age” how should the code change

[ermanoj3101 (MANOJ)]

Use as dt1.AsEnumerable().Where(Function(row) dt2.AsEnumerable().Any(Function(x) x(“name”).ToString=row(“name”).ToString and x(“age”).ToString=row(“age”).ToString)).CopyToDatatable

[Tharusha.fernando]

@ermanoj3101
Thank you