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

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
image

Expected output excel 1:

Regards,
Raja G

please provide sample files

or check post

Regards

1 Like

Hi @LAKSHMI_NARAYANA_PEMMASAN ,

What version you are using i couldnt able to open

I will do upgrade my UiPath

image

Regards,
Raja G

try opening file separately

also Please provide sample files

Regards

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

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

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

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.

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