Hi All,
I want to compare two Excel sheets having 1000 of records with some changing dynamic values. Attaching excel file for reference with Input & output.Excel_Compare.xlsx (10.2 KB)
Hi All,
I want to compare two Excel sheets having 1000 of records with some changing dynamic values. Attaching excel file for reference with Input & output.Excel_Compare.xlsx (10.2 KB)
Use “Contain”
e.g.
Assign (a=Hello World)
Assign (b=Hello)
if ( a.Contains(b) )
Then Message “Match”
Else Message “Unmatch”
This will solve your problem.
Hi @Bilal_Zafri1,
Thanks for feedback, but this isn’t the proper solution for above problem.
Use WildCard(*) in Place of Dynamic Value
Hi @Bilal_Zafri1, Could you please share xaml with solution.
Hi did u mean u need to get unmatched data rows after comparing both excel sheets @Snehal14Kapse