Exclude a dataset

Question

I want to join or union (not sure which) the below two datasets and look at the invoices in the input of invoices 1-5 and not include the invoices 3-5 from the first dataset. In other words i want to have the new output exclude invoice 3, 4, 5

Output -

invoice 3

invoice 4

invoice 5

Input -

Invoice 1

Invoice 2

Invoice 3

Invoice 4

Invoice 5

danilang · Answer

Hi @Klachner

Use a Join tool as a filter.  Join on Invoice and take either the R or L depending on which side the inputs are connected

Dan

aatalai · Answer

in the input use add filepath as output, and then filter out the files you don't want