Compare Excel with Dynamic values

Build
#1

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)

#2

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.

#3

Hi @Bilal_Zafri1,

Thanks for feedback, but this isn’t the proper solution for above problem.

#4

Use WildCard(*) in Place of Dynamic Value

#5

Hi @Bilal_Zafri1, Could you please share xaml with solution.

#6

Hi did u mean u need to get unmatched data rows after comparing both excel sheets @Snehal14Kapse