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.
alteryx Community

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!

Alteryx

A solution to last week’s challenge can be found hereSource: 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!

10 - Fireball

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

Spoiler

View my solution video here:

Spoiler
12 - Quasar

Nice challenge, @Kenda!

Spoiler

Check out my video solution :

Spoiler

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

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 🙂

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

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.

8 - Asteroid

i love it.

14 - Magnetar

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

Spoiler
Workflow

14 - Magnetar

Solution using Python's marvelous itertools,

Spoiler