Compare 2 table based on single column and update the values in sheet1 excel

[lakshmi.mp]

Hi all,

How to match single columns from sheet 1 and sheet2 and update the sheet2 data into sheet1.
I tried full join, left join but not working.

sheet1

sheet2
Expected output.

Please help me. How to do this.
Thanks,
Lakshmi

[Rounak_Kumar1 (Rounak Kumar)]

Hey,

You can use merge Data Table Activity and please follow this vedio
it will help you

UiPath Tutorial | Uipath Merge Data Table (COMPLETE TUTORIAL Addwithkey Alternative)

Thanks

[ahmad_sarrawi (Ahmad AL-Sarrawi)]

Hi,

Please try this using Linq “(From x In dt1 Join y In dt2 On x(“Invoice Doc”).tostring Equals y(“Invoice Doc”).tostring
Select tempDt.clone.LoadDataRow(New Object(){x(“SD Order”).tostring,x(“Invoice Doc”).tostring,x(“VA03”).tostring,x(“Status”).tostring,x(“Status1”).tostring,y(“Pdf_data”).tostring},False)).CopyToDataTable”

[lakshmi.mp]

Hi @ahmad_sarrawi ,

Getting error , what changes i need to do.
Thanks,
Lakshmi

[lakshmi.mp]

@Rounak_Kumar1 ,
I tried out this one. Getting this error.

What to do. Please help.
Thanks,
Lakshmi

[ahmad_sarrawi (Ahmad AL-Sarrawi)]

Ok,

Please set the initial value for DT3: new System.Data.DataTable,
and create table with expcted columns

[Rounak_Kumar1 (Rounak Kumar)]

Hey,

Use this workflow
it is working for me
New folder.zip (10.1 KB)
Thanks,
Rounak

[lakshmi.mp]

Hi @Rounak_Kumar1 ,

I tried out and the particular file, I am getting this error.

What to do.
Thanks,
Lakshmi

[Rounak_Kumar1 (Rounak Kumar)]

Have you used my Zipped File Code which i have shared
Please check

Thanks

[lakshmi.mp]

Yes I unzipped that file and executed by passing the different file with same headers.
Thanks,
Lakshmi

[Rounak_Kumar1 (Rounak Kumar)]

you are doing something wrong because my output is coming properly in Sheet 3
please verify the code and column name

Thanks

[Rounak_Kumar1 (Rounak Kumar)]

Hey,
this error comes because-

Typically happens when there is no value . Check for any null values

thanks

[lakshmi.mp]

Hi @Rounak_Kumar1 ,
I checked, in that excel there is no null values.
And column names are same as the sample file.
Thanks,
Lakshmi

[lakshmi.mp]

@ahmad_sarrawi ,
I tried by giving DT3 and created required columns in new sheet.

Getting this error.
Thanks,
Lakshmi

[rohith.prabhu]

Hi @lakshmi.mp ,

As per error message It looks like you have not added a Additional column “Pdf_data” in DT3, if not added do add column and try again.

Regards,
Rohith

[rohith.prabhu]

Hi @lakshmi.mp ,

Did you check this Post :

Compare and update the column in excel

Hello @lakshmi.mp , You can achieve this by using Merge Data Table with key option. Please refer to the below video for your reference : [UiPath Tutorial || Day 51 : Merge Data Table Activity (Along AddwithKey) || Data Table Activities] Note : You can skip the initial part of the video and start from 10mins. Regards, Rohith

Regards,
Rohith

[supermanPunch (Arpan)]

@lakshmi.mp

I tried out and the particular file, I am getting this error.

Hi @lakshmi.mp ,

The Column name that you have provided here maybe not matching with the Column names present in the Datatable, Do Check the Column Names in the Debug Panel and what you have used in the Assign Activity.

Let us know if this did not help.

[lakshmi.mp]

@rohith.prabhu ,
“Pdf_data” column has been added in along with required columns, I tried out the above video but its not working.
Thanks,
Lakshmi

[lakshmi.mp]

Hi @supermanPunch , @Rounak_Kumar1 , @rohith.prabhu , @ahmad_sarrawi .
Thanks a lot for helping, able to update the values to particular sheet.
Thank you so much.
Regards,
Lakshmi