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.
So I'm trying to build out a Macro right now and I'm running into a bit of difficulty. What I'm trying to accomplish is creating a Macro that updates the columns selected in a "Unique" Tool based on one of the two macro inputs. I'm having some trouble with the Action Tool, specificially in that it does not recognize the XML that I created with a Formula Tool.
This is an example of one of the XML inputs: <Field field="EXAMPLE" />
What I want is for that XML Input to update the column selected in my Unique Tool.
Has anyone run into this issue before and have a solution?
I believe the issue is that you're connecting the macro input to the action tool. When you build the formula in the action tool, the fields from the input tool aren't available. When you use for example a drop down instead, you get the result of that as an incoming variable to be used in your action tool. Despite the macro input connecting to it, it doesn't really work and only works when the top Q is white, like on the drop down tool.
Regardless of this, there's probably a way to get to what you're trying to do. Best would be to share the workflow.