In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more 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