community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Flat Hierarchy to a Tabular format

Meteor

I hope someone can help me with this as I tried for a few days now but with no desirable outcome. Thank you in advance

Here is my current state:

EE_IDManager_IDHierarchy_BottomUpHierarchy_TopDown
111101101
11110292
11112583
11121574
11127065
111125756
1112151047
1114354338
11116523129
11114214110
22210141
222121832
22213285423
222322314

 

Desire outcome below:

Note: Employee 111 is  a regular employee where  222 is a supervisor; that's why EE_SupvTD_Level for 111 = 0 and 222 = 5. Basically their level in the top down supervisory hierarchy.

EE_IDManager_IDSupv CountEE_SupvTD_LevelSupv_BU10Supv_BU09Supv_BU08Supv_BU07Supv_BU06Supv_BU05Supv_BU04Supv_BU03Supv_BU02Supv_BU01Supv_TD01Supv_TD02Supv_TD03Supv_TD04Supv_TD05Supv_TD06Supv_TD07Supv_TD08Supv_TD09Supv_TD10
11110110010110212521527012572151043543165231142141011021252152701257215104354316523114214
22210145      1011218132854322310112181328543223      
Alteryx Certified Partner
Alteryx Certified Partner

Hi @belouizi 

 

Here's a solution:

solwf1.PNG

 

The only thing you need to additionally do is to specify a flag indicating if the employee is a regular one or a supervisor, so we can create "EE_SupvTD_Level" column.

 

Workflow attached on version 2018.4

 

Cheers,

Meteor

Thank you so much. IT WORKED PERFECT!!

In fact, we don't need "EE_SupvTD_Level" column any more.

 

would it be possible to replace the levels by a different verbiage as below? 

 

Supv_TD01 = CEO
Supv_TD02 = DRG
Supv_TD03 = DRG-1
Supv_TD04 = DRG-2
Supv_TD05 = DRG-3
Supv_TD06 = DRG-4
Supv_TD07 = DRG-5
Supv_TD08 = DRG-6
Supv_TD09 = DRG-7
Supv_TD10 = DRG-8

 

Meteor

I was able to do it using the select tool. that was easy enough. Thanks again

Labels