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
15 - Aurora
15 - Aurora

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

 


Bulien
andrewgu
Alteryx
Alteryx

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

LiuZhang
9 - Comet
Spoiler
11.png