Multi-Row Formula Tool: Apply to only one row

[Degas]

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

[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 · Accepted solution]

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 : )

[Degas]

thanks @atcodedog05 ! 

[atcodedog05]

Happy to help : ) @Degas 

Cheers and have a nice day!