Want to perform Left Join on Two DataTables

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

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

Hi Nived,

Yes, I want to do same

Hi @Sahil_Garg1

Check this way using linq query

dt1 = Table1

dt2 = Table2

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

1 Like
1 Like

Hey ,

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

Hi @Sahil_Garg1

Can u show ur requirements with help of screenshot

Hey,

Your Solution worked,

Thanks a lot!

1 Like

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