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.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
I'm relatively new to the application. I'm trying to do something that's probably not that complex by fumbling through it, but I've hit a bit of a wall and am hoping somebody might be able to point me in the right direction. I think I'm fundamentally misunderstanding something, but I can't tell how far off I am.
So my input is:
[Group] [Period] [Value]
I want to do ABC classification of Groups by Period. So if I wanted to just be hacky, I could just just use redundant branches of filters to break it out by period calculate my ABC's and move on to whatever's next. But since this is something that I could see myself using in the future, I thought I'd try to come up with a better way to do it.
My expected output would be something like:
[Group] [Period] [PX_ABC] [PY_ABC] [PZ_ABC]
And yes, I get that based on this I would get some jagged data like:
The control parameter should be influencing the macro by updating the filter step which should select only the current period in the iteration. It should also change the output field name later on in the workflow.
In the actual workflow I feed the macro tool the aggregated data described above and a distinct list of periods.
So the problem:
My output only includes one of the expected fields. PX_ABC based on my dummy explanation, but not PY_ABC. Though, if I check the log from the workflow the batch tool does output that it's run through the expected number of iterations, I just don't see it in the output.
I guess some possibilities that I'm not sure how to troubleshoot out:
-I really haven't configured this macro correctly as far as the controls go.
-I am expecting that for each iteration of the macro it will add another field to the output. Maybe it doesn't really do this?
-Along the same lines, a lot of the calculations for the ABC piece just have generic names - like the running total and the %Of calculation. For these purposes it's a throwaway, so I don't really care, I"m just assuming they're getting added per the macro.
-I expect that my iterations just append at the end. Like my P1 stuff should just stack on to my P2 stuff. I haven't configured anything to tell it to do that so maybe there's something additional I need to add.
Macros are tricky to make and can be even harder to debug. Can you provide your macro as it stands now and some sample data? Include you input data and what you're expecting as the output. That will make tracking down the issue much easier.