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
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
you can also use UiPath’s activities - join datatables:
but after that you have to remove additional column which will be created:
seems it works fine.
Many thanks to both
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.