Filtering From an External Data Set

[catledbetter04]

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 solution]

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 solution]

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

-

[catledbetter04]

Thank you everybody!!

[AsaelMAYA]

Thanks