How to Compare and get change data

Help Activities
, , ,
5

Hi @MD_Farhan1

You can use a simple Query
dt_result = dt_input.AsEnumerable().Where(Function(x) Not dt_output.AsEnumerable().Any(Function(y) y.ItemArray.SequenceEqual(x.ItemArray))).CopyToDataTable()

This image depicts a sequence of actions in a data processing workflow, including reading data from two Excel workbooks, cloning and comparing data tables, and writing the result to an output sheet. (Captioned by AI)
This image depicts a sequence of actions in a data processing workflow, including reading data from two Excel workbooks, cloning and comparing data tables, and writing the result to an output sheet. (Captioned by AI)1062×715 34.2 KB

I have tried with same inputs you have provided and it works
Output

image
image584×106 3.34 KB

Do mark it as solution if it helps :+1:

2 Likes