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 #11: Identify Logical Groups

Anmol97
8 - Asteroid

Here's my solution

AlexBough
7 - Meteor

Solution attached 😊

jjrbondoc
8 - Asteroid
Spoiler
jjrbondoc_0-1633728983003.png

 

Neil_L
7 - Meteor
Spoiler
challenge_11_spoiler.png
TheOC
16 - Nebula
16 - Nebula

A pretty strange one - i would actually say this is an 'easy' challenge, once you understand how to do it. 

 

Spoiler
I originally started with a find/replace, but then remembered how useful an append fields can be, if utilised correctly.

TheOC_0-1633952453115.png

 

Cheers,
TheOC
Connect with me:
LinkedIn Bulien
andrewgu
Alteryx Alumni (Retired)

Solution attached.

dbmurray
8 - Asteroid

Completed

 

Spoiler
dbmurray_0-1634280291083.png

 

rswathi
6 - Meteoroid

My solution

AlexvanOs
8 - Asteroid

My solution

Spoiler
I tried with find-replace, but it showed a warning about field 6 containing too many characters, so I abandoned that one and chose to use the append tool. Then it's just a matter of checking if the search text is present, then filtering, concatenating and counting.

Challenge 11 solution.png

leozhang2work
10 - Fireball
Spoiler
11.png