Formula to add a column with relevant information

Hi Everyone,

I want to add a column to my data in alteryx which includes the name of the university. I have a list of email addresses with students university name and would like to translate this information to the name of the university.

So if my output is:

Then my ideal output would be:

I attach the dummy data for review as well. Thank you

Dummy data.xlsx

Datasets

Tips and Tricks

Transformation

Data Investigation

Accepted answers

atcodedog05

Hi @suds144

Here is how you can do it.

Workflow:

Hope this helps : )

University.yxmd

All comments

atcodedog05

Hi @suds144

Here is how you can do it.

Workflow:

Hope this helps : )

University.yxmd

suds144

Amazing! I was using the formula tool but was using a different formula so it wasn't working! Thank you!

atcodedog05

Happy to help : ) @suds144

Cheers and have a nice day!

suds144

A quick question, could you please explain why you put ".*@(\u+)\..*","$1" - what do some of the symbols account for? I understand some but not all.

Thank you

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703