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

12 - Quasar

Solution:

Spoiler
Capture.PNG
8 - Asteroid

I tried two methods:

One is Find and Replace with values as IDs to Items

Other is direct string CountDistinct approach

 

Happy Practice 🙂
2019-01-24 (3).png

Alteryx Partner

My solution

Spoiler
88.png

 

10 - Fireball

My solution with 4 tools plus in/out:

 

Spoiler
088EW.PNG
7 - Meteor

Realized I did not need to sort out empty values as they filtered out down the workflow. 

8 - Asteroid

another one completed

Alteryx Certified Partner

Nice challenge. and here is my solution.

 

Spoiler
I did get the same result, but I can see that I could have minimized it furter by doing a Count Distinct last instead of a normal count in the distinct data, but well..

2019-02-20 15_53_01-Alteryx Designer x64 - challenge_88_solution_verakso.yxmd.png

 

Still Climbing

/Thomas

13 - Pulsar
13 - Pulsar

Definitely misinterpreted this problem at first and thought I was going to need a macro to find all the combinations possible and count how many times they happened. So glad the result is included or I would have been spinning my wheels for hours.

Spoiler
Challenge 88.PNG
8 - Asteroid

A fun challenge

Alteryx Certified Partner
Alteryx Certified Partner

I've attached my solution!