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.
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 #327: A place to stay

JBevan89
8 - Asteroid

Solution attached.  I do not think the solution correctly sorted as per the question, but it does not matter as it's here nor there

3I_ATLAS
9 - Comet

Nice RegEx practice!  I'm getting half descent @PhilipMannering!

Spoiler
^.*\?location\=([[:alpha:]]+)\&.*

Challenge is not clear on the final sort order but you may consider that a bonus challenge!

Final dataset has a minor issue that in all likelihood and justifiably so, very few people (if anyone) noticed.  See below..

Spoiler
WC_327.jpg

 

Minanashat
8 - Asteroid

Screenshot 2025-03-24 095705.png

Carolyn
12 - Quasar
12 - Quasar

Solved!

 

Spoiler
2025-04-04_16-40-18.png
alineruizcampos
8 - Asteroid
Spoiler
Screenshot 2025-04-17 141625.png
pilsworth-bulien-com
13 - Pulsar

My solution:

Spoiler
327.png

RebekaMazuchova
8 - Asteroid

:)

yazen
7 - Meteor
Spoiler
yazen_0-1753859792985.png

 

panliu
7 - Meteor
Spoiler
panliu_0-1756046631869.png

 

I think I have solved it, but there's a trailing comma in Record 66 of the standard answer, which caused the mismatch.