Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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