Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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 #358: Goodbye, Michael! (Part 1)

ggruccioAYX
Alteryx Alumni (Retired)
‎02-13-2023 10:22 AM

Sometimes I forget to post under my old account to get credit!

Reply
0 Likes
Shelbey
Alteryx
Alteryx
‎02-13-2023 10:53 AM
Spoiler
Shelbey_0-1676314322681.png

 

challenge_358_solution.yxzp
Reply
0 Likes
anthonyw
8 - Asteroid
‎02-13-2023 11:19 AM

Challenge Completed! My results are a bit different from the Output. Wondering if anyone had the same results

 

 

challenge_358_start_file_Completed.yxmd
Reply
Clifford_Coon
11 - Bolide
‎02-13-2023 11:22 AM

My solution.  Straight through processing (one line) and minimal tools.

Spoiler
challenge_358.jpg

 

challenge_358_solution_ccc.yxmd
Reply
0 Likes
ggruccio
ACE Emeritus
ACE Emeritus
‎02-13-2023 11:25 AM

Fun Office challenge - not as straightforward as I initially thought!

 

Spoiler
ggruccio_0-1676316305851.png

 

challenge_358_gg_finish.yxzp
Reply
0 Likes
almeera
8 - Asteroid
‎02-13-2023 11:27 AM

almeera_0-1676316446484.png

 

Reply
Caroi42
6 - Meteoroid
‎02-13-2023 11:38 AM

Mine was a bit different - I did some data cleaning to look for spelling variations for my totals for word and line were higher.

 

 

Spoiler
358_screenshot.png

 

challenge_358_Caro.yxmd
Reply
ed_hayter
13 - Pulsar
‎02-13-2023 11:47 AM
Spoiler
ed_hayter_0-1676317609549.png

 

challenge_358_flow.yxmd
Reply
0 Likes
TurboToad
11 - Bolide
‎02-13-2023 11:56 AM

Fun challenge!

Spoiler
TurboToad_0-1676318135119.png

 

TT_challenge_358_solution_file.yxmd
Reply
LHolmes
9 - Comet
‎02-13-2023 12:05 PM

Some interesting lessons in data cleansing. Provided two solutions - one that matched and another that looks a little deeper.

 

Spoiler
358 - Solution.PNG
Just looking at "Michael"Just looking at "Michael"Looking at variations of "Michael", such as "M ichael", "Micheal", "Micahel".Looking at variations of "Michael", such as "M ichael", "Micheal", "Micahel".
challenge_358_solution_lmh.yxzp
Reply
Live Weekly Challenge