How to compare two excel files and update

[Sreekar_Mulinti]

How to compare two excel files and update

[nikhil.girish]

Hi @Sreekar_Mulinti

Please find below link for your reference

How to compare two Excel sheets and update cells with UiPath - Full Tutorial

[Sreekar_Mulinti]

For example: i want to add pincode column in first excel based on the second excel file, here the common column for both excel files are city column

[Shikhar_Tandon]

You can use join function for this.

Thanks

[nikhil.girish]

Hi @Sreekar_Mulinti

Got your point u can use lookupdatatable

How to do Excel VLOOKUPs in UiPath RPA (Full Tutorial)

Please watch this link
Definitely u will achieve on your own if not please let me know

Thanks

[Sreekar_Mulinti]

But the city column in the second excel is sorted one based on that rows i have to match and update pincode, in real project I had more columns other than pincode in second excel

[postwick (Paul Ostwick)]

Read both into datatables. Compare and manipulate the data in the datatables. Write back to Excel from the datatables.

[Sreekar_Mulinti]

thanks for help

[nikhil.girish]

No worries
@Sreekar_Mulinti happy automation