Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #39: Trouble Shooting a Broken Macro

Highlighted
8 - Asteroid
Spoiler
2020-01-01 21_24_52-Greenshot.png2020-01-01 21_25_33-Greenshot.png
Highlighted
8 - Asteroid
Tricky one with some hidden errors in there to find, definitely attempt this before watching. especially as I'm sure you can find them all in less time that ...
Highlighted
8 - Asteroid

JonathanW_0-1578441416522.png

Highlighted
Alteryx
Alteryx
Spoiler
JamesHa_0-1578604036691.pngConnected the action to the text input.  Fixed the Date time format in both DateTime tools. Allowed all appends.  Fixed the missing _ in field names for filter and formula as well as the missing ]
8 - Asteroid

Here's my solution! - This macro is also the solution for Challenge #17

Spoiler
{F856B04A-EEBB-460A-9478-8A9E66112627}.png.jpg
Highlighted
8 - Asteroid
Spoiler
Workflow
39 Workflow.png

Macro
39 Macro.png
Highlighted
8 - Asteroid

Sol attached.

Highlighted
8 - Asteroid
Spoiler
Chantelbbr_0-1580423977642.png
Highlighted
8 - Asteroid

Took me a minute to locate the final thing to fix in the macro, but seems to work like a dream now!

 

Spoiler
Capture.PNG
Highlighted
8 - Asteroid
Spoiler
tiffanyshaw_0-1581529710703.png

Macro:

tiffanyshaw_1-1581529725155.png