Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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