Batch Macro on multi row formula

[messi007]

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.

[BradWerner]

Does it have to be a batch macro or can you just use multi-row tools to make this possible for each column? See attached picture and workflow.

[messi007]

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

[BradWerner · Accepted solution]

Sounds good!

Have you already seen this thread that covers a similar use case?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Creating-a-Multi-Field-quot-Fill-Down-...

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

[Ben_H · Accepted solution]

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!

[messi007]

Dear @Ben_H,

Thank you !

You have been really helpful.

Best Reagrds,

[messi007]

Dear @BradWerner,

Thank you 🙂

You have been really helpful.

Best Regards,

[messi007]

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

[Ben_H]

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