Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!

Alteryx Designer Desktop Discussions

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

Eliminate rows from second tab

tiverson
8 - Asteroid

Hello,

 

I have a file that has multiple tabs.  One tab has a list of ALL invoices, a second tab has a list of invoices that need to be excluded.  

I want to combine the lists together and remove the invoices that need to be excluded.

 

 

Original tab 

invoice      amount

1                 10.00

2                 20.00

3                 25.00

4                15.00

5                 30.00

 

Excluded tab

3                 25.00

5                 30.00

 

New list

1                 10.00

2                 20.00

4                15.00

 

Thanks for any ideas and help

3 REPLIES 3
ChrisTX
16 - Nebula

Use a Join tool.  Left input = Original tab.  Right input = Excluded tab.

 

Continue processing only the data from the Left output.

 

This is the basic functionality of the Join tool.  If you're just starting to learn Alteryx, at the top of this page check out Learn > Academy > Learning Paths & Interactive Lessons.

 

Chris

binuacs
21 - Polaris

@tiverson One way of doing this

image.png

tiverson
8 - Asteroid

Thanks @ChrisTX @binuacs , I didn't even think to use the exception from join tool.  I knew it had to be a simple fix.  Appreciate your input

Labels