. For ex. in excel A , i have ZXRC=1, in excel B wherever i find ZXRC, i have to update 1 in next column.... its like UPDATE query in SQL...how to proceed

[indra]

@Venkat1991 Before posting check the forum if post is not there than you can post.

Refer below post

How to compare two excels in uipath?

Hello, Initially, you need to identify unique value(For example pan id or id is unique). You have to compare pan id from excel 1 and pan id from excel 2. Procedure: 1)Read Excel 1 2)Read Excel 2 3)For each row in a data table 4)Get row item (Pan id) (1st excel) (You will be getting each row in pan id column)(Stored in a variable) 5)Get row item (Pan id)(1st Excel) (You will be getting each row in pan id column)(Stored in a variable) Compare 2 variables using if Write range into Excel