Multi-Row Formula Tool: Apply to only one row

Hi everyone,

is it possible to configure the Multi-Row Formula Tool in a way that the expression is only performed for one row?

I'm trying to build an Iterative Macro where I want to apply the Multi-Row Formula only to one row per iteration. After that, a Filter Tool checks if a condition is met or not. If yes, those rows should be excluded from further processing. If not, the rows which don't meet the condition should go into the next iteration and the Multi-Row Formula Tool should be applied again for one row.

Right now, the Multi-Row Formula tool performs the expression for all rows, and then again for all rows in the next iteration and so on.

Best,

Degas

Help

Accepted answers

atcodedog05

Hi @Degas

I am assuming you are trying to do something like this. It cant be achieved with multi-row formula tool.

Hope this helps : )

fill gap.yxmd

All comments

atcodedog05

Hi @Degas

You can use if else formula in the multi-row formula tool to moderate on which rows multi-row formula is applied.

Hope this helps : )

Degas

@atcodedog05 thanks for your reply! I've been trying to do this, but I couldn't come up with a working IF-Else-Expression. I wanted to add an expression that counts the number of entries in column x and if the count is bigger than y stops the Multi-Row Formula. But I couldn't make it work.

Do you have an idea on how I could approach that?

atcodedog05

Hi @Degas

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

Degas

Hi @atcodedog05 , it could be something like that:

Product	Category
8234923	B
8234924
8234925
8234926
8234927	A
8234928
8234929	C
8234930

I want Alteryx to write A in column Category until there are 3 A's in that column:

Output would be that:

Product	Category
8234923	B
8234924	A
8234925	A
8234926
8234927	A
8234928
8234929	C
8234930

atcodedog05

Hi @Degas

I am assuming you are trying to do something like this. It cant be achieved with multi-row formula tool.

Hope this helps : )

fill gap.yxmd

Degas

thanks @atcodedog05 !

atcodedog05

Happy to help : ) @Degas

Cheers and have a nice day!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335