We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start 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.