Macro updating multi-row-formula with Numeric Up down

Question

Hey! I have a question regarding getting my multi-row formula to update in alteryx.

I have attached the macro I'm currently working on! As you can see in the end of the macro I'm trying to update the number of words chosen for the multi-row formula:

Where from the formula: if !isnull([Count]) then REGEX_Replace([Row-1:NewKPI], '(\w+)(\s|-).+', '$1') + " " + GetWord([Row-1:NewKPI], 2) + ' ' +[Field_To_Rename] else [Field_To_Rename] endif

It replaces the 2 in the GetWord.

This is working such that if I choose 1 it says "Revenue For Fisk". However, if I Choose 0 it returns "Revenue Revenue Fisk" or if I choose 2 it returns "Revenue Me Fisk".

Is there a way to make it update such that if I choose 0 it returns "Revenue Fisk", if I choose 1 it returns "Revenue For Fisk" or if I choose 2 it returns "Revenue For Me Fisk"?

Any help is appreciated!

MultipleNames.yxmc

atcodedog05 · Answer

Hi @sebastian123Han

Here is my take. You can convert the app to macro by changing input and browse to macro input and macro output.

Workflow:

Hope this helps : )

Words Select.yxwz

Christina_H · Answer

Here's an updated version that I think should do what you need

MultipleNames.yxmc

sebastian123Han · Answer

Hey!

Yeah I can see it is not really clear. This was the scenarios I was imagining 🙂