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

Never used vertical layout.  Very interesting.

Spoiler

15 - Aurora

Interesting challenge, thank you @Kenda. It took me some time to get used to the vertical layout, but I will definitely try it again.

Spoiler

5 - Atom

Seems like I had a relatively novel/compact solution compared to those posted so far!

I'm normally a horizontal user but enjoyed trying vertical for once.  Weird to me to move the log to the right hand side to add to my available space.

8 - Asteroid

Everybody seems to have a different solution. Here is mine:

Spoiler

7 - Meteor

Hello,

It's my first time submitting an answer and the first time using Alteryx. The magic happens on the formula step.

I also can't use the vertical layout as I don't find them compact enough to fit one screen wherever possible. And if a function to pick the nth lastest value would exist, my solution would be more elegant, in my opinion.

Thank you for the challenge, @Kenda.

12 - Quasar

Here's my solution:

Spoiler
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
11 - Bolide

Bit of a brute force approach, which works for this small sample, else worth considering a python tool

Edit: much prefer the version with generate rows.

🙂

Spoiler

6 - Meteoroid
Spoiler

8 - Asteroid

Don't know whether its the right way but used Generate Rows Tool to get the desired combination output. Anyways the best part, got to learn about the tool.

Spoiler
Workflow:

Thanks & Regards,

Allwyn Thomas

8 - Asteroid
Spoiler
Solution Attached