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

jarrod
ACE Emeritus
ACE Emeritus

No Macro

Simple Macro

Batch Macro

Spoiler
jarrod_0-1594739785343.png

 

FredNajjar
9 - Comet
Spoiler
FredNajjar_0-1597199547759.pngFredNajjar_1-1597199570071.png

 

Tisaac95
8 - Asteroid

Struggled a lot with this one. Had to look at a few solutions for inspo when having to find the number of bottles in a batch.

 

JethroChen
10 - Fireball
Spoiler
challenge_66_jc.PNG
tammybrown_tds
8 - Asteroid

I needed to peek at others' solutions to get this one.  I haven't worked with macros enough.

 

Spoiler
Alteryx Challenge 66.png
AkimasaKajitani
17 - Castor
17 - Castor

My solution. I make Iterative and Batch Macro.

 

Spoiler
I use the Filter tool to catch the error. So the error records are output to another output.

Workflow
AkimasaKajitani_2-1599271408652.png

 



Iterative Macro Version
AkimasaKajitani_0-1599271342469.png


Batch Macro Version

AkimasaKajitani_1-1599271378056.png

 

 

JoePC
9 - Comet

Solution Attached

Sylvana
8 - Asteroid

My solution.

Billigans
8 - Asteroid
Spoiler
Billigans_0-1602126507643.png

 

Uff, that took me so much longer than I thought! But proud of my macros - a standard one where the user can choose the box size and then a batch macro that uses a list of whatever box sizes. 😌