ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. 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 #358: Goodbye, Michael! (Part 1)

TanbirJ99
Asteroid

My Solution

 

Spoiler
TanbirJ99_0-1686135652725.png

 

Dani_Lin
Asteroid

solved

IPJR
Meteor

Done.

quinnmb
Meteor

Not the most efficient probably, but I did it. 

WaltReed
Asteroid

My numbers were slightly different

Spoiler
Screen Shot 2023-06-15 at 15.02.43.png

rohityaman
Asteroid

Nice one! Use CountWords function to match the word count result. I was trying regex earlier.

 

Spoiler
rohityaman_1-1686865126881.png

 


 

jackgmoroney
Meteoroid
Spoiler
jackgmoroney_0-1687072811487.png

 

Tgigs
Asteroid

My solution attached.

 

First 3 questions pretty simple, use summarize tool to group by and then count the records. Last question used get words function in formula tool and then summed up the number of words.

Swathi
Comet

PFA for solution

jacobcarman
Comet
Spoiler
Screenshot 2023-07-07 152444.png

 My solution.