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

Help Studio
, ,
1

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

2

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

3

Hi @poonati.p

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

4

testex2.xlsx (8.2 KB)

sorry my bad , second excel also have name columns

5

Hi @poonati.p

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

6

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

7

where should we assign these values?

8

in a separate column

9

in which excel file?

10

in second excel

11

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]

Regards,

Nived N

Happy Automation