How to join two dt

Hi,
i’ve DT1 with name,surname,Tax ID
and DT2 contains car, Tax ID
I want a DT that contains only the row in DT1 with Tax ID not contained in DT2.
How can i achieve that in uipath?
Thanks in advance

Hi,

Can you try the following expression?

dtResult = dt1.AsEnumerable.Where(Function(r) not dt2.AsEnumerable.Select(Function(r2) r2("Tax ID").ToSTring).Contains(r("Tax ID").ToString)).CopyToDataTable

Regards,

1 Like

hey,
you can also use UiPath’s activities - join datatables:
image
but after that you have to remove additional column which will be created:

seems it works fine.
Many thanks to both

1 Like

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