Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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!