How to match two data table particular value found update in match row

[Raja.G (Mr.RPABot)]

Hi Team,

I want update some details one data table to another data table based on account no.
If any account no match that row should update Ac.no and Ad.no column value

Please anyone help me for this.

excel 1

excel 2

Expected output excel 1:

Regards,
Raja G

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

please provide sample files

or check post

How Update values from one sheet to another sheet in excel

I Want to Search Bot and Process name if it is equals then update values like Completed , Error , Progess, Manual Review. [image] [image]

Regards

[Raja.G (Mr.RPABot)]

Hi @LAKSHMI_NARAYANA_PEMMASAN ,

What version you are using i couldnt able to open

I will do upgrade my UiPath

Regards,
Raja G

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

try opening file separately

also Please provide sample files

Regards

[postwick (Paul Ostwick)]

This is called a join. It’s a basic database function.

https://docs.uipath.com/activities/other/latest/user-guide/join-data-tables

[Raja.G (Mr.RPABot)]

Hi @LAKSHMI_NARAYANA_PEMMASAN /Team ,

I want to fine account no excel 1 to excel 2 find the matches once found the account no for example A5 than update column of D5,E5 “Ac no” and “Ad no” from excel 2 to update excel 1

Regards,
Raja G

[postwick (Paul Ostwick)]

Read both Excel files into separate datatables. Then Join Data Tables, designating the account number columns as the columns to match. This will give you a single datatable with all columns from both Excel files, aligned by account number. Then you can use that datatable to write what you need back to Excel.

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

please provide sample files

also confirm excel is going to be standard so new records will get added

and second file is going to be additional file to capture the required fields

Regards