Eliminate rows from second tab

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

exclude test.xlsx

Transformation

Accepted answers

binu_acs

@tiverson One way of doing this

Exclude_21052024.yxmd

All comments

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

@tiverson One way of doing this

Exclude_21052024.yxmd

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

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335