Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found hereSource: GIPHYSource: GIPHY

 

This challenge comes to us from @ramesh_neel - thank you for your contribution!

 

The input file has names of users connected by commas in a single field with random numbers to each name . Some of the names start with a lower case and some have middle name to them. [ names generated using a random name generator website ]

 

Create a set of email IDs (using @testemail.com as the domain) using a combination of first letter of the first name + last name of the user [even if they have a middle name ] and grouped into A-Z categories. Provide a count of the number of emails in each group.

 

Hint - In your output exclude any users without a valid name ( i.e, does not contain a number)

Aaron_Harter
11 - Bolide

Fun challenge to start the week!

Spoiler
211.PNG

 (edit 4/13 10:31 CDT) video of solution overview:

Spoiler
johnemery
11 - Bolide

Fun challenge! Good way to get the gears running on a Monday morning.

 

Spoiler
Like we've seen many, many, many times before, RegEx is king. It's absurd how handy regular expressions are for these types of problems.

Capturev2.PNG

  Check out my solution video here:

Spoiler
dsmdavid
11 - Bolide

Regex is the answer. The question is pretty much irrelevant.

Spoiler
dsmdavid_0-1586788173260.png

 

Blake
12 - Quasar

What is Forrest Gump's email password? 

Spoiler
1forrest1

 

Spoiler
Blake_1-1586788335231.png

 

 

mbogusz
9 - Comet
Spoiler
2020-04-13 10_48_51-Greenshot.png
Sudha8990AI
8 - Asteroid

It is very fun 🙂 It will be more fun if we have more than duplicate mail id.  

Victor_Mendes
8 - Asteroid

My solution

Spoiler
Victor_Mendes_1-1586798724420.png

 

 

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
4 tools! 
Capture.PNG

MOHAMMEDAFZAL
7 - Meteor

EAT

SLEEP

REGEX

REPEAT

Spoiler
MOHAMMEDAFZAL_0-1586800023331.png

Just 5 tools 🙂