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
Solved! Go to Solution.
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
@tiverson One way of doing this