Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #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
11 - Bolide

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
22 - Nova
22 - Nova

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
13 - Pulsar
13 - Pulsar

Here is my inefficient answer!

patrick_digan
17 - Castor
17 - Castor
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

 

Sashikumar
8 - Asteroid

i love it.ch231.PNG

PhilipMannering
16 - Nebula
16 - Nebula

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

 

Spoiler
WorkflowWorkflow

 

 

PhilipMannering
16 - Nebula
16 - Nebula

Solution using Python's marvelous itertools,

 

Spoiler
PhilipMannering_1-1598890379031.png