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

OllieClarke
15 - Aurora
15 - Aurora

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