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.

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!

RobertW
Alteryx
Alteryx

Never used vertical layout.  Very interesting.  

 

Spoiler
RobertW_1-1598890394542.png

 

RolandSchubert
15 - Aurora
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
231.png

 

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

etzele
8 - Asteroid

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

Spoiler
etzele_0-1598896002148.png

 

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

cgoodman3
12 - Quasar
12 - Quasar

Here's my solution:

Spoiler
Challenge 231.png
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
dsmdavid
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
dsmdavid_0-1598902514846.png

 


 

 

alexdel
6 - Meteoroid
Spoiler
alexdel_1-1598901778262.png

 

allwynthomas24
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:

challenge_231_solution_AllwynThomas_Spoiler.PNG

Thanks & Regards,

Allwyn Thomas

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1598903826204.png