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

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

ChrissD
7 - Meteor

Failure to Import C:\Users\etc\challenge_11_start_file.yxzp.
There was an error opening "C:\Users\etc\challenge_11_start_file\challenge_11_start_file.yxmd":

This workflow was created by a more recent version of Alteryx, and may contain tools or functionality not present in this version.

 

I'm on Alteryx 2018, soon to install v2019 so I'm a bit confused that a file from 2016 doesn't work. Could you update the files used here? 

 

@GeneR 

 

jackdaniels
8 - Asteroid
Spoiler
Capture.PNG
rmassambane
10 - Fireball
 
Trumble_dup_334
7 - Meteor

Now this was a head scratcher, but a real world text problem for any form of Customer Service team. Liked the challenge, and doubt this looks anything like the solution. but I got there.

 

Spoiler
Challeng #11 Solution T.JPG

Tisaac95
8 - Asteroid
Spoiler
 

Not completely correct but a solution...

TarunDeep
8 - Asteroid

Fell for the logic intially, now getting the correct output.

 

Spoiler
Solution_Challenge_11.JPG

 

Hjardine
8 - Asteroid
Spoiler
Hjardine_0-1577992009069.png


formula tool to assign buckets, tranpose to get into one column, summarize tool to concatenate values, another summarize tool to count each bucket, filter for non-blanks

paulburrows
8 - Asteroid

Happy New Year!!

JonathanW
8 - Asteroid

All done

 

JonathanW_0-1578374355518.png

 

Original_Yodies
8 - Asteroid

could have been harder without taking a little time to think first.

Spoiler
Original_Yodies_0-1578452963857.png