This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
It sounds like you need to build this with only one Macro Input and one Macro Output. Be sure to de-select the field map on the Macro Input tool. Beyond that, I would use a pair of Detour tools controlled by a checkbox on the macro so you can control Formula 1 or 2 when you place it in a workflow.
The Macro Input and Detour tools should be field agnostic in this macro. Nothing should be passed to the Formula tool not passed from the detour route. You can double-down on this by putting each Formula in a Tool Container that disables that tool in accordance to the Detour route.
Sorry for the delay, @jda996 I've been on vacation since my last post.
I put together the attached example that shows that the macro should not validate formulas/tools that are in the detour path not taken. Maybe there's an error elsewhere in your macro? Looking at the error, what tool is ToolID 17?