Dear Alteryx Community,
I have an input like this:
C1 | C2 | C3 |
AA | BB | CC |
A | B | C |
And I want to use a macro batch and muti-row formula to get this
C1 | C2 | C3 |
AA | BB | CC |
AA | BB | CC |
AA | BB | CC |
A | B | C |
A | B | C |
A | B | C |
What I have done is this:
Howerver on the action I can update [Row-1:C1] in order to change the column.
Attached my simple workflow.
Many thanks in advance 🙂
Regards.
Solved! Go to Solution.
Hello @BradWerner,
Thank you for the quick reply 🙂
However I already have done this but I have more then 3 columns...
That's way I wanted a dynamic option using a batch macro in order to batch on every column.
thanks again!
Regards
Sounds good!
Have you already seen this thread that covers a similar use case?
They reference this blog post in the solution.
http://sculptingdata.com/alteryx/building-a-fill-down-macro-in-alteryx/
Let me know if you have already seen this or if you have questions after this and we can help look into it further.
Thanks!
Brad
Hi @messi007,
Here's an alternate method that doesn't require a batch macro.
With this method you transpose the data first, that way you only have to use the multi-row formula once.
You can then crosstab the data back into it's original format.
(I added the extra column just to quickly test different data)
Regards,
Ben
edit: I've just noticed that this is what the thread linked above by Brad recommends!
Dear @Ben_H,
When I run your solution this what I get:
The column A45 it's not working properly.
Many thanks in advance:)
Regards
Hi @messi007,
It is working correctly it just gives a different output to the screenshot I posted.
For whatever reason I seem to have deleted the EE value out of the input, if you were to put it in on the top row you'd get the same output.
Regards,
Ben