Filtering From an External Data Set

Question

I have a listing of approximately 1M lines with various invoice numbers loaded into Alteryx (data includes additional columns such as dates, amounts, etc. that I want to retain in the output). I want to filter this population for about 30K invoice numbers I have saved down in a excel document. Is there a easy way to accomplish this? The only data I have in the external excel file is the invoice #s so no other fields match my data set I have loaded into alteryx outside of the invoice #.

Luke_C · Accepted Answer

Hi @catledbetter04

Join the excel file to the data on the invoice #. The 'J' output of the join tool will only be those invoices.

https://help.alteryx.com/20214/designer/join-tool

NeilParrott · Accepted Answer

Hello @catledbetter04 ,

@Luke_C  is thinking the same thought I had for this.

Here are some screenshots to see an example of the Join tool using invoice number.

Hope this helps!

Neil

-