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.

[alexnajm]

Sure - if you want them to type,  Text Box Tool is your answer! I am not sure why you want to avoid a Join though - I would have the values update a Text Input, split to rows using a Text to Columns, and Join against the original data

[jrlindem]

I agree with @alexnajm that using a JOIN is ideal.  If you're trying to avoid duplicate values coming in if the user adds one twice, then you can simply add Unique Tool or Summarize (Group By) Tool after the Text Input to force distinct records.

Also, for what it's worth, using Alex's approach also allows you to do some quality checking and cleansing steps on the user inputs so they don't have to be as prescriptive about format when they're entering values (ex. Trim(), Upper(), Lower(), Removing Symbols, etc. so that it matches your data source format).