Interface Filter

VascoA

I am building an Analytic App in Alteryx Designer where the user selects an Excel file that contains an “Account” column.
I would like the user to enter multiple account values (separated by “;”) via the Interface, and have the workflow filter the selected Excel data accordingly — without using any Join tools.

Pilsner

Hello @VascoA,

Like @alexnajm and @jrlindem I too would initially have approached this with a Join tool; however, if you don't want go down that route, you could use a filter tool and an In statement.
 
It would work as follows:

Here's my input data (this can obviously be changed for an input data tool which updates based on a user selection, however it sounds like you already have that part, please let me know if not).

1) Add a filter tool to the canvas, and write an In statement such as the following:

2) Set an action tool to overwrite the "1,2,3" with the text entered by a user, (if you want to use ";" as a delimiter instead of a "," you may need to update the filter based on a formula, which replaces all the ";" with ","):

3) The app then works as follows:
Input:

Output:

I do feel the need to mention that this is prone to potential issues, such as users mistyping the account codes, or putting a "." instead of a "," leading to a different output. The way to get around this would be to use a more controlled user interface element, such as the List box, as per @Qiu's solution, however, if you want to stick with the text box, I believe my solution should work as you expect. 

I've attached the worklfow below incase you wanted to take a further look. Please let me know how you get on.

Regards - Pilsner

Workflow.yxwz