community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Help loop fomula

Alteryx Certified Partner

I want loop processing.
I want to make a simple loop.
I would like to do something like to VBA like Do Loop and Do Until for use with アルタリクス.
I can not do that.

For example, adding 1 row additing and 1 row adding
and finish condition
· 100th line
Or
· Accumulation reached 100
thats it.


I wanted to calculate by adding a row until I could not make it.

Please give me a hint.
Thank you.

Alteryx Certified Partner
Alteryx Certified Partner

Check out the generate rows tool.

 

https://help.alteryx.com/9.5/GenerateRows.htm

 

you may also want to look into the multirow tool, i'm not to clear on what you are looking for.

 

Ben

Bolide

@SaoriYamguchi,

 

I have had the most luck using the Multi-Row Formula Tool. You can get pretty creative using the group by functionality. I have attached and example of how to do a sum until limit and summing by partition. This should get you started down the right path.

 

Best,

MSalvage

Alteryx Certified Partner

Hi @SaoriYamguchi,

 

I'm not sure if I fully understood what value should be if a new row is added, however, this should give you a better idea of how to get your solution. 

image.png 

Updated macro attached...

 

Hope this helps!

 

Jimmy

Alteryx Certified Partner

@BenMoss

@MSalvage

@jrgo

 

Thank you for reply.

I study to macro and formula.


@SaoriYamguchi wrote:

I want loop processing.
I want to make a simple loop.
I would like to do something like to VBA like Do Loop and Do Until for use with アルタリクス.
I can not do that.

For example, adding 1 row additing and 1 row adding
and finish condition
· 100th line
Or
· Accumulation reached 100
thats it.


I wanted to calculate by adding a row until I could not make it.

Please give me a hint.
Thank you.




 

 

Labels