Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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

OllieClarke
16 - Nebula
16 - Nebula

I'm glad I don't have to do this too much...

Spoiler
Challenge 39.PNG
MarMu
8 - Asteroid

 

Highly relevant challenge!

I remember doing the macro in a previous challenge (challenge #17, yes I looked it up). I recall spending quite some time figuring out the logic.

Otherwise pretty straight forward to find the bugs.

 

Spoiler
challenge_39_start_file_MarMu.png
JoBen
11 - Bolide

Cheers!

JoBen
11 - Bolide

Sorry, here's the attachment!

pasccout
8 - Asteroid

Here is the fixed macro

kbwissi
8 - Asteroid

Only took about 10 minutes - nice!

StevenBetts
8 - Asteroid

Here's my solution :)

 

Spoiler
Challenge 39.jpg
Changes made:
Attached the action tool to the input data
Selected the correct parsing pattern on both datetime tools
Changed append option to allow all appends
Corrected the field names in the filter and first formula tool
Added a square bracket to the formula in the first formula tool

acrahen
8 - Asteroid

Nice one for those getting started with macros

 

Spoiler
2018-10-29_09-02-28.png
jssandom
8 - Asteroid

Nice debugging challenge!

NilsM
8 - Asteroid
Spoiler
AlteryxChallenge39.PNG