Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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

nini
8 - Asteroid

My Solution:

kmcdaniel
8 - Asteroid
Spoiler
screenshot11.png
ddiesel
13 - Pulsar
13 - Pulsar

My solution:

 

Spoiler
Capture.JPG
KT2
7 - Meteor
Spoiler
 

Boom.

Sebenius
8 - Asteroid

intresting chaning on the input but my old solution did the trick still:

Spoiler
clipboard_image_0.png

 

erick_irigoyen
Alteryx Alumni (Retired)

Solution attached

SueDonim
8 - Asteroid

I had downloaded the data before it all changed, so was working with the larger dataset.

 

I inadvertently plugged the search values directly in the formulas, rather than link to it.  I might redo the exercise to deal with that, but this seems pretty good ATM

 

Only issue is a discrepancy of 55 trigger complaints (my number is lower), but all the others match.  I'm guessing this is an issue with the truncated fields which is probably why the challenge was revised.

 

Spoiler
Process:
- Replace the complaint row separator of "." with "|" so it's easier to work with
- Add Record ID to allow for grouping
- Revise Record ID with Multi-Row tool such that it only increments if there is a pipe separator
- Flag instances of search term for all 7 permutations of the search term
- Aggregate with Group By Record ID and count all instances of each permutation
- Sum each of the 7 permutations
- Remove double-counting
- Transpose data to get it in columns
- Sort (descending) and Clean-up

MySolution.PNG
ArnavS
Alteryx Alumni (Retired)
 
sgrabish1
8 - Asteroid

Easy to do with guide alongside; thanks for the practice

KatieA
Alteryx Alumni (Retired)

Solution attached