Formula to filter for information by particular names

Hi Everyone,

I'm trying to filter event names by the administrator attached to it. I've tried to create a formula (and also used the join tool) but am unable to successfully filter information out. I could do this in excel but it would take time and I'm hoping alteryx will help.

Ideally, I need to filter for information that only has admin name "CC" in it.

Input

Ideal Output:

Thank you!

Dummy data.xlsx

Datasets

Output

Tips and Tricks

Optimization

Accepted answers

Contains only allows one string. You would need to do an OR clause like the below.

New Workflow2.yxmd

All comments

You would use a filter tool with the 'contains' function:

New Workflow2.yxmd

Hey @suds144 You can also use Contains or In function -

Thank you! What if there are various different names in place of "CC". To modify the formula in Contains should I just add a comma?

Contains only allows one string. You would need to do an OR clause like the below.

New Workflow2.yxmd

Thank you everyone!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15878

MarqueeCrew 13708

apathetichell 13703