Hi guys. I need help to solve this. i have 2 excel file like Old Data and New data both have common column. unique identifier is email id. now i want to find which row is change and get write in new data sheet2. upload below screenshot for your refence. Thank you Old data: [Screenshot 2025-04-1…

check the argument of Invoke code. You have mentioned dt_Change not dt_Changes. Obviously it will give an error. [A software interface displays an error message indicating that the variable 'dtChanges' is not declared while showing a table of data arguments including 'dtChange.' (Captioned by AI)…

How to Compare and get change data

Help Activities

Pavan_Kumar_Gente (Pavan Kumar Gente) April 11, 2025, 8:13am 8

Hi Farhan,

Please check the attached simple solution.

Forum2.zip (12.4 KB)

Here’s the output:

If it resolves for you. Please mark it as solution.

Happy Automation

Pavan Kumar Gente

Topic		Replies	Views
Compare 2 excel files with the same columns and remove all duplicats Help datatable , excel	5	2090	March 23, 2020
Excel Comparison Issue Help	11	949	May 28, 2019
Compare 2 datatables and update row("email") from datatable Forum datatable , excel , studio , question	4	1077	April 26, 2022
Comparing Data Tables Help excel , uiautomation , activities	1	3725	November 9, 2017
Compare two different data tables through linq Studio uiautomation	9	2748	January 19, 2022

How to Compare and get change data

Related topics