cancel
Showing results for
Did you mean:
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
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.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

## Challenge #66: My Wine Problem

Highlighted
Sr. Learning Strategy Manager

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

Bolide

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

Sr. Learning Strategy Manager

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

Alteryx Certified Partner

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

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Alteryx Certified Partner

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

Spoiler

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.

Pulsar

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.

App for testing the macro with new values.
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

Sr. Learning Strategy Manager

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