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 #88: Counting Combinations

Highlighted
14 - Magnetar
14 - Magnetar

My solution!

 

Spoiler
WeeklyChallenge88.JPG
Highlighted
Alteryx Certified Partner

Originally I thought this was a Market Basket excercise, so if I bought Milk, what else was purchased with Milk...then I realised how stupid I was and re-worked my workflow! @ChristineB Market basket would be a good challenge one week

 

Spoiler
Weekly Challenge 88.PNG

 

 

Highlighted
Sr. Instructional Designer
Sr. Instructional Designer

Great idea, @LordNeilLord!  In fact, @Joe_Mako had that same thought and his solution to this week's Challenge explores some possibilities with the Market Basket tools.  If you have some ideas as to what a challenge might look like for MB Analysis,  I'm open to all/any suggestions! 

Highlighted
Alteryx Certified Partner

Here's my solution.

 

Spoiler
challenge-88.png
Highlighted
Alteryx Certified Partner

Deleting a duplicate post

Highlighted
8 - Asteroid
Spoiler
88_CountingCombinations.JPG
Highlighted
16 - Nebula
16 - Nebula

Good fun & quick challenge 

 

Spoiler

2017-10-11_11-57-11.png

Highlighted
16 - Nebula
16 - Nebula

Good fun & quick challenge 

 

Spoiler

2017-10-11_11-57-11.png

Highlighted
14 - Magnetar
14 - Magnetar

Late in the game answering this challenge. My solution isn't unique. Fun, simple challenge, and great to learn that the concatenate function of the summarize tool ignores the Nulls!

 

Spoiler
Spoiler

The first summarize tool concatenates the items (in alpha order). The second counts the unique strings from the first.

image.png
Highlighted
Alteryx Certified Partner

A bit late to the game, but this is a fun first challenge. I look forward to trying many more in the future!