Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #11: Identify Logical Groups

Highlighted
Meteoroid

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 

 

Highlighted
Asteroid
Spoiler
Capture.PNG
Highlighted
Asteroid
 
Highlighted
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

Highlighted
Meteoroid
Spoiler
 

Not completely correct but a solution...

Asteroid

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

 

Spoiler
Solution_Challenge_11.JPG

 

Highlighted
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

Highlighted
Asteroid

Happy New Year!!

Highlighted
Asteroid

All done

 

JonathanW_0-1578374355518.png

 

Highlighted

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

Spoiler
Original_Yodies_0-1578452963857.png