Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #39: Trouble Shooting a Broken Macro

Highlighted
10 - Fireball

#39

Highlighted
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

 

 

Highlighted
Alteryx Partner

Jackpot. Macros are my bag baby!

Highlighted
Alteryx Partner

Hi 

Here's my solution

 

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

Cheers

Amr

Highlighted
Alteryx Certified Partner

Here is my solution !

Highlighted
8 - Asteroid

Fixed

Highlighted
Alteryx Partner

Challenge #39 solved 

 

Annotation 2020-05-23 195854.png

 

Highlighted
11 - Bolide
Spoiler
 
Highlighted
12 - Quasar
12 - Quasar

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