Eliminate rows from second tab

[tiverson]

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

[ChrisTX]

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

[binu_acs · Accepted solution]

@tiverson One way of doing this

[tiverson]

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