Unstacking multiple formula tools

[MarkMcCullagh]

I created a workflow with multiple formula tools working on the same field. Another user modified and improved the workflow and did what Ican only describe as stacking the formula tools on top of each other. I was unfamiliar that you could do this and am uncertain as to how you unstack them. Can anyone guide me in what is probably a very basic question. 

Thanks in advance

mark

[Per]

If I understand correctly you had the same formulas before, but just in different formula tools rather than 1? There is then no easy way to 'unstack' them. You will need to copy each formula into their own formula tool again I believe.

However, I am curious as to why you want to do it, as it takes quite a bit of space in the workflow, rather than keeping it a bit cleaner as it is now?

[MarkMcCullagh]

For explanation purposes to someone unfamiliar with Alteryx. How do you copy them? Is it copy paste the formula text? Incidentally how do you stack them to begin with?

[Per · Accepted solution]

Yes, start by expanding one of the formulas you want to move

Then copy the formula text

Add a new formula tool after the first one

Paste the formula into it and remember to select the field name

Adn then delete the formula in the first tool

Then you should end with a workflow looking like this

When you want to stack formulas, you add a new one by pressing the + button

Hope it makes sense, otherwise shout out 🙂

[MarkMcCullagh]

Thank you Per for a good explanation.

[PhilippK · Accepted solution]

Hi @MarkMcCullagh ,

In case you are having even more formulas and you are a very technical person - you can think about opening the Alteryx workflow with a normal editor (as it is only an XML file) and adjust the formula tools via adjusting the xml code:

Best regards

Phil 

[MarkMcCullagh]

Thanks @PhilippK