Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

mbogusz
9 - Comet
Spoiler
2020-01-01 21_24_52-Greenshot.png2020-01-01 21_25_33-Greenshot.png
Nicholas_Bignell
8 - Asteroid
JonathanW
8 - Asteroid

JonathanW_0-1578441416522.png

JamesHa
Alteryx Alumni (Retired)
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 ]
James Dolan-Hall | Principal Technical Account Manager
support@alteryx.com | community.alteryx.com
Marcel_Gavrila
8 - Asteroid

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

Spoiler
{F856B04A-EEBB-460A-9478-8A9E66112627}.png.jpg
BradWerner
11 - Bolide
Spoiler
Workflow
39 Workflow.png

Macro
39 Macro.png
Parul_Kapoor
8 - Asteroid

Sol attached.

Chantelb
9 - Comet
Spoiler
Chantelbbr_0-1580423977642.png
jmt214
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
tiffanyshaw
8 - Asteroid
Spoiler
tiffanyshaw_0-1581529710703.png

Macro:

tiffanyshaw_1-1581529725155.png