Want to perform Left Join on Two DataTables

Help
,
1

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

2

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

3

Hi Nived,

Yes, I want to do same

4

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
5
1 Like
6

Hey ,

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

7

Hi @Sahil_Garg1

Can u show ur requirements with help of screenshot

8

Hey,

Your Solution worked,

Thanks a lot!

1 Like
9

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