I do a lot of disaggregating of data based on certain characteristics, which generally requires a bunch of summarize tools to be put into the workflow and individually configured. I had an infomercial moment and thought there had to be a better way, which led me to making a macro (more specifically a macro nested in another macro) that would allow me to quickly disaggregate and get counts for a variety of different suggestions. Most of the time I am also adding a higher order disaggregate (e.g., disaggregate based on gender and ethnicity), so I have an interface element that allows me to specify that as well. The problem I am currently running into (and the reason for my post) is that if I don't want a higher order disaggregate and select [None], I get the error "Field names must not be blank" and "a record was created with no fields."
I have deduced that the problem is in my nested macro I am changing one of the fields to be [None] which creates a blank and yields no fields. I have tried as many ways as I can think of to do this within the Alteryx interface, to no avail. I have also included a packaged workflow with sample anonymized data.
Thus my question: is it possible to conditionally remove a "group by" field from a summarize tool within a macro?
