Multiple user inputs used in filter

Hi All,

Very new to Alteryx so patience is appreciated. What I am trying to accomplish is to allow a user to enter a set of words then filter a separate set of input data by those strings. For example - if one of the fields was names. I would like to allow the user to input Jack,Jim,Jess,Jane and have the output be filtered for only those names. I realize the below is far from working but just wanted to depict what I am trying to get at.

Any help for a new user would be appreciated!

Alteryx attempt.png

Workflow

Tips and Tricks

Accepted answers

DavidP

Would something like this work for you?

Create a Text input with a placeholder set of names, then update this list from the Text box and Action tool. Convert the comma separated list to rows and use a join tool to grab the selected names from your input file.

See workflow attached.

user input names.png

user input names.yxzp

All comments

DavidP

Would something like this work for you?

See workflow attached.

user input names.png

user input names.yxzp

mbarone

What David posted will indeed work just fine, but I thought I'd give another option, depending on what you want the user experience to be.

In this solution, the user enters their list of strings, one per line, no commas needed. By default, it will be case insensitive.

Here's my workflow:

In the filter tool, have a custom filter of 1==1.

Configure your Text Box tool like this:

And your action tool like this:

That formula is as follows: '[cust_first_or_bus_name] IN ("'+REGEX_Replace([#1],'\n','","')+'")'

Processcreator

Thank you both for your replies.

MBarone - I attempted your method - however the filter doesn't seem to be actually working - all of the original data is passing through the filter unaltered

Can't really trouble shoot as I do not know how this filter is working. My workflow is the same as yours. Car Name is a column in the data set

Filter.png

ACtion.png

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703