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.
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #231: What a Combo!

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found hereSource: https://commons.wikimedia.org/wiki/File:Combination.pngSource: https://commons.wikimedia.org/wiki/File:Combination.png

 

This week's challenge was submitted by @Kenda  - Thanks for your submission!

 

Mathematicians and statisticians often work with permutations and combinations. In this challenge, we will focus on the latter. You are given 15 unique variables. The goal is to create a list of each of the combinations containing 3 variables (that is, 15C3). Remember, with combinations, order does not matter and the same variable cannot show up more than once in a given combination.

 

Since @Kenda is vertical user, this week's challenge is also a vertical workflow!

johnemery
10 - Fireball

Enjoyable challenge, but that vertical layout.... oof.

 

Spoiler
Capture.PNG

 View my solution video here:

Spoiler
Blake
12 - Quasar

Nice challenge, @Kenda!

 

Spoiler
wc231.png

Check out my video solution : 

 

Spoiler

 

atcodedog05
17 - Castor

Fun challenge. Knew combinations for a while, but this is the first i am implementing.

 

Thank you for this challenge @Kenda 

 

got agree with @johnemery . Suddenly working with vertical flow is not easy.

 

Spoiler
atcodedog05_0-1598882355615.png

PS: I started with vertical flow eventually moved to horizontal orientation.

I wonder whether any other way of optimizer tool exist for this.

 

Cheers and Happy Analyzing 🙂

Aaron_Harter
11 - Bolide

Thanks @Kenda for the fun challenge!

 

While I respect the vertical canvas orientation, I switched my canvas to horizontal to fit my annotation style:

Spoiler
231.PNG
phottovy
11 - Bolide

Here is my inefficient answer!

patrick_digan
16 - Nebula
16 - Nebula
Spoiler
I tried to make it "dynamic" so that it could be turned into a macro easily. For small datasets like this, I like holding info in comma separated strings. I did that A LOT in the AdventOfCode AlteryxOfCode challenges last December.
patrick_digan_0-1598885881586.png

 

skumar_31
8 - Asteroid

i love it.ch231.PNG

PhilipMannering
14 - Magnetar
14 - Magnetar

Thank you @Kenda! Not yet a vertical convert, but will try it from time to time.

 

Spoiler
WorkflowWorkflow

 

 

PhilipMannering
14 - Magnetar
14 - Magnetar

Solution using Python's marvelous itertools,

 

Spoiler
PhilipMannering_1-1598890379031.png