Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #11: Identify Logical Groups

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

Solution

Highlighted
8 - Asteroid

Thanks, enjoyed the challenge.

Highlighted
Alteryx Partner

another opportunity to Regex

Spoiler
MikeLR_0-1604937620401.png

 

 

Highlighted
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

 

Highlighted
8 - Asteroid
Spoiler
Capture.PNG

KIS = keep it simple

Highlighted
Alteryx Partner

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

Spoiler
NikitaParab_0-1605695297110.png

 

Highlighted
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
Highlighted
Alteryx Partner

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

Spoiler
simbert_0-1606214979354.png

 

Highlighted
8 - Asteroid

Here is my submission!

Spoiler
workflow.png