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 stored in a new excel file. thanks in advance
try if this helps…
but change the condition
@ashley11 thanks for the reply,let me check once and get back to you.
sure if you face any problems then you can send your xlsx files we will sort it out @venkatmalla6
The logic for doing this is as follows
Use Lookup Datatable activity after reading both Datatbles (similar to excel vlookup)
next based on if out value is found you add that row to a new data table
This is the fastest method without code
@venkatmalla6 your expected out put matched the out put of the program ?
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)
Great @venkatmalla6, please mark an appropriate solution so that others can benefit in future
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.