Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!

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
Bólido

Fun challenge to start the week!

Spoiler
211.PNG

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

Spoiler
johnemery
Bólido

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
Bólido

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

Spoiler
dsmdavid_0-1586788173260.png

 

Blake
Cuásar

What is Forrest Gump's email password? 

Spoiler
1forrest1

 

Spoiler
Blake_1-1586788335231.png

 

 

mbogusz
Cometa
Spoiler
2020-04-13 10_48_51-Greenshot.png
Sudha8990AI
Asteroide

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

Victor_Mendes
Asteroide

My solution

Spoiler
Victor_Mendes_1-1586798724420.png

 

 

 

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

MOHAMMEDAFZAL
Meteoro

EAT

SLEEP

REGEX

REPEAT

Spoiler
MOHAMMEDAFZAL_0-1586800023331.png

Just 5 tools 🙂