Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #39: Trouble Shooting a Broken Macro

AndrewS
11 - Bolide

#39

steven4320555
8 - Asteroid

The problem appeared in a previous weekly challenge. Good to see how others approached the problem, while debugging. 

Spoiler
steven4320555_0-1586987173352.png

I copied the content of the macro into a normal workflow to debug, but I guess there should be a better way. Will look through some examples to learn. 

Spoiler
I was happy to see the formula used in this example is very similar to the one I used in week 17. 

steven4320555_0-1586987971255.png

 

 

joshuaburkhow
ACE Emeritus
ACE Emeritus

Jackpot. Macros are my bag baby!

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
AMansour
11 - Bolide

Hi 

Here's my solution

 

Spoiler
Capture d’écran 2020-04-30 à 00.48.48.png

Cheers

Amr

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

Sylvana
8 - Asteroid

Fixed 🙂

AngelosPachis
16 - Nebula

Challenge #39 solved 

 

Annotation 2020-05-23 195854.png

 

deviseetharaman
11 - Bolide
Spoiler
 
jarrod
ACE Emeritus
ACE Emeritus

good chance to work on best practice of troubleshooting

Spoiler
make sure macro works if you run in "debug mode"
if you get errors, track back through the rest of the process
DavidLane
8 - Asteroid

I have lost count of how much time I have spent debugging macros over the psat few months - luckily there was nothing too nefarious in here.

 

Spoiler
DavidLane_0-1591272574209.png