Formula to add a column with relevant information

[suds144]

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

[atcodedog05 · Accepted solution]

Hi @suds144 

Here is how you can do it.

Workflow:

Hope this helps : )

[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 :)

[atcodedog05]

Hi @suds144 

".*@(\u+)\..*" in this (\u+) means take only letters which come after @ symbol. Wrapping with brackets () makes it a capture group and this will be first and only group

"$1" means replace the whole string with only the text in the first group.

Hope this helps : )