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.
Use WildCard(*) in Place of Dynamic Value