I want to compare the two columns from different excel sheets ,each row has fixed names , if the row name matches with row name in another excel then we need to compare the values ,if values are not same we need to take the difference ,please help me

testex1.xlsx (8.1 KB) testex2.xlsx (7.9 KB)

@Balamareeswaran_Muru @uI_path1 @megharajky @Sailaja_Chikkam @PrankurJoshi
guys could you please help me

Hi @poonati.p

I think in second excel file, there is only value column ?

testex2.xlsx (8.2 KB)

sorry my bad , second excel also have name columns

Hi @poonati.p

Actually what u need to do if they had same name ?

if the name matches i need to compare the values
for example
taylor has different values so we need to take the difference of the,
pradeep has same values so we can assign zero

where should we assign these values?

in a separate column

in which excel file?

in second excel

Hi @poonati.p
Try this sequence
Main.xaml (10.6 KB)
testex1.xlsx (8.1 KB) testex2.xlsx (8.6 KB)

[Please note: i dont how the difference is taken, but u can interchange it accordingly in assign activity]


Nived N

Happy Automation