Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

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

Kenda
16 - Nebula
16 - Nebula
Spoiler
The T anchor on the Append Fields tool can be changed from the given input to the app input, but my macro does each of the 6, 12, and 96 box sizes!

Capture.PNG
RichoBsJ
11 - Bolide

Hi! Here my (spaniard wine) solution for your wine problem :)

OllieClarke
15 - Aurora
15 - Aurora

here's my batch macro version :-)

Spoiler
challenge 66.PNG

For the other version, replace the control parameter with a numeric up/down
JonathanAllenby
8 - Asteroid

Here's my solution to challenge 66!

 

Spoiler
Challenge66_MacroScreenshot.PNG


I would have preferred to do an iterative macro on this one I think.

I also did it as a batch macro but didn't give each box a separate output - unsure if this is fine or not.

hanykowska
11 - Bolide

good one, Thankfully I wrote everything down and the implementation wasn't too bad

RolandSchubert
16 - Nebula
16 - Nebula

My solution using the batch macro approach.

ponraj
13 - Pulsar

Here is my solution. 

 

Spoiler
Main workflowMain workflowBottle distributionBottle distributionAppending Box sizesAppending Box sizes
JoshuaGostick
11 - Bolide

Went for the Bonus solution.

Spoiler
challenge_66_macro.PNG
Spoiler
challenge_66.PNG
Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 66 is done!

Spoiler
challenge 66 JMS solution.PNGchallenge 66 JMS solution macro.PNG
kelly_gilbert
13 - Pulsar

Great macro practice!

 

Spoiler
challenge_66_outer workflow.PNG



Basic macro (runs once for each order, given a box size):
challenge_66_order macro.PNG



Box-size macro (runs the basic macro for each box size):
challenge_66_box batch macro.PNG