We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Exclude a dataset

Klachner
7 - Meteor

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

 

2 REPLIES 2
aatalai
15 - Aurora

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

danilang
19 - Altair
19 - Altair

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

Labels
Top Solution Authors