How to get difference records of 2 datatable

[itbuddy1]

Hi,

My query is how we get difference records between 2 datatabe.
I’ll already tried linq but that gives me wrong output.

[mkankatala (Mahesh Kankatala)]

Hi @itbuddy1

Could you share you LinQ Code or the input files then we will provide you the LinQ code.

Hope it helps!!

[itbuddy1]

sure,
I’ll provide you the input files

[itbuddy1]

Input1.xlsx (9.1 KB)
Input2.xlsx (8.9 KB)
Required output.xlsx (8.9 KB)

[Gaurav_Malhotra]

@itbuddy1

Just follow this link:

Compare two datatables and get unique value from dt1

Hi, I am facing one problem, I have two dt dt1 - ID 1 2 3 4 dt2- ID 4 5 6 I just want rows present in dt1 but not in dt2.

Hopefully it helps

[Praveen_Mudhiraj]

Hi @itbuddy1

You can try this in invoke code

Dim rowsToRemove As New List(Of DataRow)
For Each x As DataRow In in_dt1.AsEnumerable()
    For Each y As DataRow In in_dt2.AsEnumerable()
        If CInt(y("CASE ID").ToString).Equals(CInt(x("CASE ID").ToString)) Then
           rowsToRemove.Add(x)
            Exit For
        End If
    Next
Next

For Each i As DataRow In rowsToRemove
    in_dt1.Rows.Remove(i)
Next

[mkankatala (Mahesh Kankatala)]

Thank you for sharing the input files @itbuddy1

You can use the vb code in the invoke code activity to get the difference records of 2 datatables.

Dim rowsToRemove = (From row1 In dt1.AsEnumerable()
                    Join row2 In dt2.AsEnumerable() On CInt(row1("CASE ID")) Equals CInt(row2("CASE ID"))
                    Select row1).ToList()
 
For Each rowToRemove In rowsToRemove
    dt1.Rows.Remove(rowToRemove)
Next

Check the below workflow for better understanding,

Output →

Hope it helps!!