community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #39: Trouble Shooting a Broken Macro

Bolide

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
Asteroid

Here is my solution

Bolide

Good exercise for diagnosing macro issues.

Alteryx
Alteryx

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)



Asteroid

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

Alteryx
Alteryx

My solution:

Highlighted
Asteroid

Somehow made it to work :)

Asteroid

Solved.

Bolide

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

Asteroid