Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #211: Generating Email Addresses

balajilolla
8 - Asteroid

Enjoyed solving this challenge!

 

Spoiler
Solution Attached
ramesh_neel
11 - Bolide
11 - Bolide

@kelly_gilbert  - Thanks for solving this and I am so glad you liked it! Cheers

Alteryx ACE | Sydney Alteryx User Group Lead | SparkED Contributor and Mentor
AbhilashR
15 - Aurora
15 - Aurora

Solution attached

randreag
11 - Bolide

Here is my solution

Kennybarker29
5 - Atom

Evening,

 

This is my second Weekly Challenge - had a go after scoring 79.9% on the Core Certification which i'm devastated about. Definitely not the most elegant solution after looking at some others here - and i had a bit of a nightmare with the RegEx, but it definitely works!

goyalrav
5 - Atom
Spoiler
Capture.PNG

My First Workflow!!

 

Steph_Maddrell
8 - Asteroid

My solution attached and screenshot below

 

Spoiler
stephM_0-1588004870394.png

 

Kale_Malcom
8 - Asteroid
Spoiler
Kale_Malcom_0-1588027145061.png

 

first time I've used the OR | in regex...

Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 211 is done...Regex to the rescue! (formulas can be seen in the spoiler below)

 

Spoiler
image.png

Filter formula: REGEX_Match([Users], '.*\d+$')

Formula (Email_Group): Uppercase(REGEX_Replace([Users], '^([A-Z]).*', '$1'))

Formula (Users): REGEX_Replace([Users], '^([A-Z]).*\s(.*?)\s?\d+$', '$1$2') + '@testemail.com'

duartepimentel
8 - Asteroid

Fun challenge!

 

Solution attached