Complex Problem - Unable to Solve

[HowRy002]

Team - 

I have a workflow that produces 5 columns (StepID, Action Cadence ID, Step Name, Parent Step Name, and Step. 

The goal is to properly identify the steps. Step 1 is where [Step_Name] = RootNode, Step 2 is where [Parent_Step_Name] = RootNode, Step 3 is where the [Step_Name] associated w/step 2 appears in the [Parent_Step_Name]. I'm trying to create a dynamic formula that can properly label the step columns with a 1, 2, 3, 4, etc. Would appreciate any input anyone can offer. Thanks - Ryan

[OllieClarke]

Hi @HowRy002 

This is basically the same problem as weekly challenge #12, have a look at it, and its solutions here: https://community.alteryx.com/t5/Weekly-Challenges/Challenge-12-Creating-an-HR-Hierarchy/td-p/36740

[Raj · Accepted solution]

@HowRy002 
find the workflow attached

mark done if solved.

[HowRy002]

Thank you