Free Trial

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 #66: My Wine Problem

JP_SDAK
8 - Asteroid

Yet another good challenge for practicing macros.  Also used the test tool for the first time.  Had to peak, I was clueless on how to test for errors  without an application.

Spoiler
Workflow:
JP_SDAK_0-1604532740473.png

Macro:

JP_SDAK_1-1604532772828.png

 

 

lainecaruzca
8 - Asteroid

My solution. I wanted to practice batch and iterative macros, so I've made 2 solutions.

Ross_Easton
8 - Asteroid

This one hurt my brain but solved!

 

Spoiler
66.PNG

Qiu
21 - Polaris
21 - Polaris

Error detection not so perfect.

Spoiler
en-66.PNG
Romy
7 - Meteor

I created an iterative macro to solve the problem. Then basically applied the macro three time before union all the outputs together, which achieves the same results as using a batch macro.

 

Spoiler
2020-11-24 10_01_52-Alteryx Designer x64 - challenge_66_macro.yxmc.png

 

michael_leoni
8 - Asteroid
Spoiler
Please see my solution below
JoshuaM
9 - Comet

My solution was dynamic based off of box size. With an error if a non number was input. Didn't quite understand the range selection so no bonus points there. 

Spoiler
Challenge_66_snip.PNG

 

mikeprice17
8 - Asteroid

My solution

djodts
8 - Asteroid

My solution as a batch macro.  I added a few tools so that each box size (6, 12, 120) would be printed to one PDF on separate pages.

Spoiler
djodts_0-1609198393489.png

 

Spoiler
djodts_1-1609198420045.png

 

 

JasonHu
8 - Asteroid
Spoiler
workflow.png

Here is my first macro challenge submission.