Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

A2H
11 - Bolide
Spoiler
Capture d’écran, le 2020-10-22 à 16.01.47.png
JBraithwaite
8 - Asteroid

Solution

WernerE
8 - Asteroid

Thanks, enjoyed the challenge.

MikeLR
8 - Asteroid

another opportunity to Regex

Spoiler
MikeLR_0-1604937620401.png

 

 

JP_SDAK
8 - Asteroid

I kept thinking this should use the tile or multi-field binning tool for buckets, but finally realized it was better done with regex functions and summary tools.

Spoiler
JP_SDAK_0-1605066313924.png

 

DN
8 - Asteroid
Spoiler
Capture.PNG

KIS = keep it simple

NikitaParab
8 - Asteroid

Tried doing it with Find and Replace tool at first. Was a fun challenge

Spoiler
NikitaParab_0-1605695297110.png

 

p-g
8 - Asteroid

My Solution. Took me some time to get the logic right as Alteryx does not support Nested IFs (only Nested ELSEIFs but not Ifs within Then). But totally worth it.

 

Spoiler
p-g_0-1605950662410.png
simbert
8 - Asteroid

Not the most elegant of solution but it does the trick!

Spoiler
simbert_0-1606214979354.png

 

JasonHu
8 - Asteroid

Here is my submission!

Spoiler
workflow.png