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 #22: Identify Values to Aggregate

AndrewS
11 - Bolide

#22

parvez
6 - Meteoroid

clipboard_image_1.png

ken_yap_au
8 - Asteroid

I would suggest having a look at how other people are solving this challenge 🙂 

ken_yap_au
8 - Asteroid

Looking at some of the other solutions, Regex Tokenise seems ideal for this (although I didn't know about it at the time). 

DanJ3
8 - Asteroid
 
JP23
7 - Meteor

Done!

jarjarbingie
8 - Asteroid
Spoiler
clipboard_image_0.png
erick_irigoyen
Alteryx Alumni (Retired)
 
kennetheng
8 - Asteroid

Used Text to Columns twice and used a filter instead of the unique tool. 

JennyMartin
9 - Comet
Spoiler
AWC22.PNG

Nice simple challenge