hii guys,i have a scenario where i need to compare two excel sheets which contains some data let’s say i have a id=89765 if this same id contains in second excel it has to store that entire row in new excel sheet,in the same way it has to compare all the id’s and the matching id’s values should be s…

hi @venkatmalla6 I think linQ will be the better option in your case, I’ll suggest you to use .Any method of linQ. I’m attaching my sample workflow here, for your understainding. matched.zip (19.0 KB) [1] [2] Result: [3]

Comparing two excel sheets and make it into new excel file

Help

ashley11 (Ashley Nihal Dcunha) June 20, 2019, 5:31am 2

try if this helps…
but change the condition

2 Likes

Topic		Replies	Views
Compare 2 Excel and saving the result in another excel Help	4	948	March 6, 2019
Matched and Unmatched data in excel Help datatable , excel , activities , question	10	2917	March 5, 2020
How to compare 2 data table and if match found then take that value and paste it on new excel! Help datatable , excel , activities , question , data_manipulation	11	1651	November 21, 2019
Compare two separate excel file data row by row Help	2	1544	December 3, 2018
Compare Excel/Lookup Data Table without getting same value Activities excel , activities , question	6	932	September 27, 2020

Most Active Users - Yesterday
Anil_G
NIVED_NAMBIAR
sesa499170
class_materials
ashokkarale
Anelisa_Bolosha1
naveen.s
eray_atasoy
Aniesah_Malong
SACHIN_BILE1
More details...

Comparing two excel sheets and make it into new excel file

Related Topics