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

cplewis90
13 - Pulsar
13 - Pulsar

Fun challenge! Most of the questions I get are helping troubleshoot problems and issues that have arisen in a workflow or macro. It is a good skill to practice troubleshooting!

Spoiler
Challenge 39.PNG
Anastasiia
8 - Asteroid

Here is my solution

T_Willins
14 - Magnetar
14 - Magnetar

Good exercise for diagnosing macro issues.

TonyA
Alteryx Alumni (Retired)

This was a great exercise. I would really like to see some comments on the process people used to troubleshoot the macro.

Spoiler
In my case, since I'm not terribly experienced with some of the tools, I made a copy of the macro, attached the input file and eliminated the interface tools. This way I could run through the workflow and see what was failing where. Of course that meant I never tested the control but the big red exclamation point was a pretty good clue that something was wrong there.
Problems I found:

1. Missing close bracket on "Close Date" in Formula(5)

2. Incorrect field renaming for "Open Date" and "Close Date" in Select(17)

3. Target and Source inputs swapped on Append Fields(11) [Looks like other people fixed this by allowing all appends]

4. Action(10) not connected to Text Input(9)

5. Incorrect date formats for conversion in DateTime(15) and DateTime(16)



bkclaw113
9 - Comet

Don't know that I would really classify this one as being about macro's.

DavidThorpe
Alteryx
Alteryx

My solution:

Mausam
8 - Asteroid

Somehow made it to work :)

rachelgatto
8 - Asteroid

Solved.

smoskowitz
12 - Quasar

Here is my entry. Had me scratching my head a little.

CRowlatt
8 - Asteroid