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