cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Welcome to Alteryx Academy! We hope you enjoy the journey. Let us know how we can improve your learning experience by completing this survey.
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.

Challenge #66: My Wine Problem

Alteryx
Alteryx

Last week's challenge is posted HERE!

 

OK, I have a problem... for you to solve!

 

We are selling bottles of wine - each of which has a unique ID since it's a limited vintage.

Customers can request their wine bottles be delivered in various different sizes of delivery box.

Customers order wine in ranges - from ID 1 to 25 for example.

 

Challenge: Build a macro that takes in order ranges, allows the user to input the box size, and outputs the order broken into the requested box sizes.

 

There are 3 sample outputs displayed to test the different box sizes:
- Box size of 6
- Box size of 12
- Box size of 96

The macro must check for, or prevent 3 specific error conditions:
- a null value for either the from or to value on an order range
- non-numeric values in the from & to values
- situations where the from ID is greater than the to ID

 

BONUS - Instead of using an interface tool to allow the user to set 6/12/96 box sizes, build a batch macro that will package all three scenarios at once!
DOUBLE BONUS - Complete this challenge whilst listening to some UB40

alex
Bolide

The solution output for #3 has box size of 96 not 120?  triple bonus to do both :>

Alteryx
Alteryx

Thanks for pointing that out @alex! I updated the exercise and the post to reflect 96. However, the beauty of this macro could be that you could test all packaging conditions :) Triple bonus?! I'm feeling generous - why not?

Quasar

My solution. I use the same macro to output all three scenarios.

 

Spoiler
WineBottleGroupings.png
Natasha
Alteryx Certified Partner

Definitely no bonuses for me as it took me ages and I appended all 4 box sizes instead of using a batch macro.

 

 

Spoiler
Screen Shot 2017-04-17 at 20.56.57.png

 

 

Alteryx Certified Partner
Alteryx Certified Partner

@JoeM,

 

I created a standard macro that calculates all 3 options at once.  No batch required.

 

Cheers,

Mark


===> https://community.alteryx.com/t5/Engine-Works-Blog/SANTALYTICS-2017/ba-p/93770 <===
Chaos reigns within. Repent, reflect and reboot. Order shall return.
BenMoss
Alteryx Certified Partner

I'm not shooting for bonus points this time round ;)

 

Spoiler
2017-04-18_00-27-06.png

I believe I have catered for 2 of the three error conditions but I am a bit confused as to what is expected in the case of 'non-numeric values in the from & to values', but you can take a look at my macro too see how I have dealt with this.

 

My solution! And my kind of problem!! :) (Admission: I finished this one with a glass of red, red wine right next to me. Cheers!)

 

Spoiler
Tested for 6/12/96/120 bottles of wine, just for kicks. Although let's be honest, 120 bottles is probably the only one that's necessary... :)

Figuring out the macro portions was the hardest part for me since i haven't had much exposure so far. Originally I tried to have a dynamic selection of box size as well, but I need to do a little more macro-playing before I go that route it appears, so we're sticking with basic inputs for this one. Included the app file I used to test my theories. 

I might revisit this one though. I'm not convinced my conditions are working 100%. And I am convinced the box selection could be dynamic. 
WeeklyChallenge66.JPG

App for testing the macro with new values.
WeeklyChallenge66MacroTest_NicoleJohnson.JPG
MinaGO
Meteor

Nice challenge! Wasnt as bad as I originally thought it would be but I definitely use too many tools. Personally I liked the idea of three separate outputs so I added a standard macro outside my batch to give S, M, L outputs. Cant upload packaged workflows for whatever reason so only screen shots this time :).

 

Spoiler
Screenshot (320).pngScreenshot (319).png

 

Alteryx
Alteryx

Wow @NicoleJohnson! Now there has to be some sort of bonus for that! ;)