Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

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: Troubleshoot a Broken Macro

cchandler21
Alteryx Alumni (Retired)

See attached!

KBL
Météore

Hi Everyone,

Not much about macros related task but anyway troubleshooting is interesting.

Solution attached (a few changes to fix runtime as well as logical issues.

Cheers,

Krzysztof

CandiceDB
Alteryx
Alteryx

I do love a good debug sesh! My solution:

 

Révélation
CandiceDB_0-1621543420883.pngCandiceDB_1-1621543427138.png

Corrected date conversions, connected action tool, allowed all appends and corrected column names in Filter and Formula tools.

apathetichell
Arcturus

more fun with batch macros.

Thableaus
17 - Castor
17 - Castor

I've done this challenge in the past, but here it goes again

 

Révélation
Thableaus_0-1623201820729.pngThableaus_1-1623201841885.png

I think it was easy because there was no logic fix. When you need to fix the logic, things can get harder. But good enough to practice.

 Cheers,

paultno
Astéroïde

My solution.  

cwkoops
Astéroïde

Repaired 😅

brandon_bunney
Astéroïde

Attaching solution to challenge #39

RashedDS
Astéroïde

My solution

 

ExploreMore
Astéroïde

This was interesting! A different use of the skills I've been developing!

Révélation
Challenge 39 is clearly related to Challenge 17. Completing 17 earlier made completing 39 a little easier for me.

Screenshot 2021-07-25 164325.pngScreenshot 2021-07-25 164342.png