Want to perform Left Join on Two DataTables

Sahil_Garg1 · January 5, 2021, 9:00am

Dear Forum Members,

I have two Data Table and i want to perform the join shown in image in uipath.
left-join-null

Can anyone help?

Regards,
Sahil Garg

NIVED_NAMBIAR · January 5, 2021, 9:03am

Do u mean u need to get the values which are only in table1 not in table2?

Sahil_Garg1 · January 5, 2021, 9:06am

Hi Nived,

Yes, I want to do same

NIVED_NAMBIAR · January 5, 2021, 9:57am

Check this way using linq query

dt1 = Table1

dt2 = Table2

dt3 = dt1.AsEnumerable().Except(dt2.AsEnumerable(),System.Data.DataRowComparer.Default).CopyToDataTable

sandeep13 · January 5, 2021, 9:20am

Sahil_Garg1 · January 5, 2021, 9:43am

Hey ,

Thanks for your reply but this expression is not performing the desired operation

NIVED_NAMBIAR · January 5, 2021, 9:45am

Can u show ur requirements with help of screenshot

Sahil_Garg1 · January 5, 2021, 9:57am

Hey,

Your Solution worked,

Thanks a lot!

system · January 8, 2021, 10:01am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.