Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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
14 - Magnetar

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