Multi row formula to multiple columns

[Inactive User]

Hi Everyone,

How to apply multi row formula to multi columns in alteryx, find below sample data:

A       B       C

10     20     30

.         .         .   

.         .         .

.         .         .

.         .         .

If isnull ([A]) then [row-1: A] else [A] endif

Can anyone help ?

Thanks & Advance !

[Luke_C]

Hi @Inactive User 

Transpose the data and use one multirow formula to fill in the blanks, then cross tab back:

[FrederikE]

There is no way to do this directly. I would recommend transposing the column, so you get: 

Name Value

A      10

A       ... 

A      ....

A

...

B      20

B      ...

...

Then you can use the multi-row tool and all three columns are included. You just need to specify in the IF-Clause that the Name has to be equal.

[PhilipMannering]

Don't really recommend this...but..

from ayx import Alteryx
Alteryx.write(Alteryx.read('#1').ffill(),1)

...in the Python Tool should do it.