Excel topics

Hello, Team!

I have 2 excel files that contain the following information.
I want to bring the “ClientName” information from file 2 to file 1.
How could I do that? The files contain hundreds of rows …

Thanks in advance!

file1
image

file2
image

@LZlz ,

Do the following steps

  1. Read both excels using “Excel Application Scope” activity separately into 2 datatable
  2. Use Merge Datatable activity - https://docs.uipath.com/activities/docs/merge-data-table
  3. Update the file1 with the output from step #2

U can use join datatable by using the InvoiceNo. Column