In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start 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 #20: List Parsing

Koji_B
8 - Asteroid

Here is my solution

Dazzerman
11 - Bolide

This challenge was a hard one to get my head around the data!  Also found an extra phone number with the Regex I came up with.

 

Spoiler
Challenge20.jpg
DataTester
8 - Asteroid
 
DataTester
8 - Asteroid
 
Inactive User
Not applicable
 
JamesCameron
8 - Asteroid

My effort. Plenty of brute force and ignorance, not much elegance!

 

Spoiler
JamesCameron_0-1574167046194.png
Lily_Unsworth
8 - Asteroid

That was hard.

KolsumaAktar
8 - Asteroid

solutions attached

mheinze
Alteryx Alumni (Retired)

Very challenging one. Found a few records that look like they have mangled phone numbers in the address field that the solution does not split out. 

moritzsturm
7 - Meteor

Solution attached with a few improvements over model output.

 

More specifically, duplicate whitespace was removed and phone number was recognized (i.e. split from address) for the following:

 

  • Group O
  • GM Customer Relationship Management
  • Regency Direct Marketing (I) Pvt. LTD
  • Metrics Marketing Group