community
cancel
Showing results for 
Search instead for 
Did you mean: 
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.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #66: My Wine Problem

Bolide

Fun challenge! I was able to create a macro that boxed all the different sizes. 

Spoiler
Challenge 66.PNG
Alteryx
Alteryx

Didn't go for the bonus. I had a lot of struggles trying to figure out how to manage compares when the types of the columns might be different from one run to the next. Finally sorted it out.

Spoiler
Two things I learned: First, ToString() can accept a string parameter and not throw a type error. Similarly ToNumber() can accept a number parameter. Second, Int16: Forced can be very handy.
Asteroid

my solution:

Asteroid

used two macros to solve this. 

Highlighted
Asteroid

Going for the double-secret bonus.  Used a chunk macro I already built for another purpose.

 

Spoiler
2019-04-25_11-06-15.jpg2019-04-25_11-09-33.jpg2019-04-25_11-06-23.jpg
Asteroid

As a few people mentioned I found how this was worded to be very confusing as well.  They kind of missed the point of having numbered bottles . . . they need to be unique.

 

However, for this challenge to work you need to assume that the order number and the bottle number make up the composite unique key, so OrderID1 can have BottleID 1, and the completely seperate OrderID 2 can also have a bottle with BottleID1.  Think of it more like 1.1 and 2.1.

 

Anyway I did end up with a batch macro handling the box size, calling an iterative macro sorting the bottles into the boxes.

Asteroid

My first batch macro. Took a while

 

Spoiler
challenge 66 solution Eleonora Nazander.JPG
Alteryx Certified Partner
Alteryx Certified Partner

Challenge #66, done.

 

Spoiler
Solution_Challeneg_66.PNGBatch_Pic_Challenge_66.PNG

Cheers,

Alteryx Certified Partner

agree with @MarqueeCrew that batch is not needed for this scenario, went for it for practice.

 

Spoiler
ch66.png
Bolide

Fun batch macro practice.  I did this during breaks during the Advanced Macro class at #Inspire19

Spoiler
Macro 66.GIF

 

 

 

 

Spoiler
Workflow 66.GIF