Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Flat Hierarchy to a Tabular format

belouizi
7 - 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      
3 REPLIES 3
Thableaus
17 - Castor
17 - Castor

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,

belouizi
7 - 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

 

belouizi
7 - Meteor

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

Labels