Filtering datatables based on another datatable

Help
1

Hi

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?
image

2

Hi @MarkusDS

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!
Kind regards,
Jacqui

3

Did you try google the following phrase “vb.net left outer join datatable”
I am sure it will give you plenty answers :slight_smile:

EDIT: “vb.net left join datatable” indeed :slight_smile:

Cheers

1 Like
4

@MarkusDS
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)

1 Like
5

Thanks, this was really helpful!

6

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