@Martin Reyes, I'm referencing your post Transform Pipeline Best Practices 

Especially the point "If you need to break formulas into two separate steps, you have to have a blank step between them".

How does this work exactly in the system? I can see, that the order is in an alphabetical manner, but cannot be changed. How can you change the order?

Regards, Fabian

@Hardev Raikmo, can you check this with your engineers?

Thanks and regards, Fabian

Hi @Ryan Paul, thanks for your answer, but "Use the Evaluation Order tab to sequence the order of evaluation of your formulas". How can we change the evaluation order you mentioned in the linked Transform Pipeline post?

Is there a response to the questions @Fabian Woldsen?

Your comment has been very helpul

Adding a snapshot here for better reference

Once you are in formula step / see the second tab at the bottom  ~  this is where "Formulas Step Order" is located

then just switch your own formulas

Regards

Eduardo

Thanks for adding that Eduardo!

Was looking forward to reading the Transform Pipeline Best Practices  but the link says "unauthorized".

Any idea why?

I'm getting the same - Unauthorised

Same

Hi @Shannon Wallner- is there a reason why we cannot access this one?  If I need to tag someone else for these types of things, let me know - and thank you as always!   https://tbmcouncil.jiveon.com/docs/DOC-5511 

Hi @Fabian Woldsen!

In my formula step it does not show the formulas in an alphabetical manner in tab "Formula Step Order".

I am on version Version r12.3.3.1.18.

Best regards,

David

Hi All,

I took a peek and it appears that this document is behind a curtain and available for Apptians and Partners only.  However, I think this is great information from which all TBMAs can benefit so I've already contacted the document owner to see if I can move it to a public space.  Stay tuned... I'm sure I'll be able to make this information available to you all soon.

Deb

Hi Folks,

I've gotten approval to move the document referenced by @Fabian Woldsen out to where you all can access it as well. It's now located in Education Services... 

Transform Pipeline Best Practices 

Happy Monday!

Hi @Debbie Hagen, I just came across this post, but I too am seeing the "Unauthorized" message, when I select the link.  Has the document moved again?  Thanks for the help 

Hi @Samir Banker, no it hasn't moved again and it appears to be on a public facing page.  @Logan Brown can you check Samir Banker's permissions as well as the permission level of this page to see why it may not be visible?

Thanks!

Deb

Thanks Deb!  No biggie... we are in the process of upgrading from R11, so I'm just happy that we are finally getting to learn R12  

I'm late to this post but wanted to ask this question. If you had 15 formulas and you wanted to change the order is that possible? I only see an Ascending or Descending and I don't know if you change the sort if that really changes the logic. When I try to look at the document it says not authorized. Thanks - Sofia

Hi Sofia, you can't sort the order of the formulas in the pipeline but if your goal is to say that formula 1 must happen before formula 2, you can do this.  You'd need to add 2 separate formula steps to your pipeline with at least one other step in between.  The between step could be something like a date partition, but if you have no step to enter, then we typically add a group step or I've also seen people use a hide and rename step... we don't put anything in the step, it's really just a place holder.  Here is an example that the product uses in the Fixed Asset Master data.

We added a group step between two formula steps and don't group by anything. It does result in an error but in this case it's an acceptable error.  We do this because we can't have 2 consecutive formula steps.

here is what it would look like from the formulas perspective.  Using the group step between the two formulas steps, ensures that the formula or formulas in the first Formula step run before those in the second step.

Does that help?

Thank you Debbie. This was very helpful. Now I have to test it for myself to see what mess I can make (jk).

LOL @Sofia Angeles,

Have fun with that. :-)