Search

Close

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

No Macro

Simple Macro

Batch Macro

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.

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

Alteryx Challenge 66.png

My solution.　I make Iterative and Batch Macro.

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

Workflow

Iterative Macro Version

Batch Macro Version

I use the Filter tool to catch the error. So the error records are output to another output.Workflow Iterative Macro VersionBatch Macro Version

Solution Attached

My solution.

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