How to compare the 2 Excel by unique Element (EmpId)?

@keerthi_97
Find a demo XAML here:
keerthi_97.xaml (11.4 KB)

I did a setup with dummy data but it should match to your structure as close as possible
The scenario of nonmatching rows or only new rows in Update Excel is initially incorporated.

Let us know your feedback

2 Likes