How to compare a row in excel with a column in another excel?

studio

#1

Can any one help me with the logic for how to compare a row in one excel with the data present in the column of another excel?


#2

Hi @deepaksvg99,

Using Read range activity to get the data from two excel sheet.
Then compare the datatable.

Regards,
Arivu


#3

Hello :slight_smile:

You just have to read both excel files using Read Range Activity and then loop through it using the If activity to compare each value.

@EDIT
Check it out those topics. It might help you :wink:

Hope It Helps.

Regards,