Dear Alteryx Community, I have an input like this: C1C2C3AABBCC ABC And I want to use a macro batch and muti-row formula to get this C1C2C3AABBCCAABBCCAABBCCABCABCABC 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. TestMultiRow.yxzp

Batch Macro on multi row formula

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.

TestMultiRow.yxzp

Batch Macro

Accepted answers

BradWerner

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-quot-Macro/td-p/6995

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

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!

Fill Values.yxmd

All comments

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.

2020-09-16 Fill Rows.yxmd

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703