I have two datatables. One with invoice information and the other is a blacklist with invoicenumbers. The last one only contains one column with the invoice numbers.
I would like to filter the first datatable, so only the rows with invoice numbers NOT present in the blacklist datatable.
I could do a for each row for the first dt and check if the invoice number value is equal to a for each on the blacklist, but that seems somewhat impractical.
So it is the one in the middle of the left side that i would like to do. Can i achieve this by putting it in an assign?
There are two ways to join datatables in UiPath. The first is using the join datatable activity and the other is using a LINQ query. The assign method would work with a LINQ query.
My preference is using the join datatable activity.
Please let me know if you have anymore questions!
Have a great one further!
Did you try google the following phrase “vb.net left outer join datatable”
I am sure it will give you plenty answers
EDIT: “vb.net left join datatable” indeed
as already mentioned, its about left outer join
can be done with join datatatable
starter help here:
Get_MatchingNonMatching_JoinActivity.xaml (13.7 KB)
or with LINQ:
LINQ_LeftOuterJoin.xaml (9.7 KB)
Thanks, this was really helpful!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.