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

ddiesel
13 - Pulsar
13 - Pulsar

Solution:

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

Alekh
9 - Comet

My solution

Spoiler
88.png

 

EW
11 - Bolide

My solution with 4 tools plus in/out:

 

Spoiler
088EW.PNG
JMX
7 - Meteor

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

Sajeel_Kershi
8 - Asteroid

another one completed

Verakso
11 - Bolide

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

cplewis90
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
papalow
8 - Asteroid

A fun challenge

Jonathan-Sherman
15 - Aurora
15 - Aurora

I've attached my solution!