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

Supervisory Level Top Down

belouizi
7 - Meteor

Hello Everyone,

 

I am building a supervisor hierarchy, and I am having some difficulties reversing my bottom up hierarchy levels.. Basically, I want to keep my first 3 columns and reverse the fourth one to have my desire outcome.

Please see below an example and let me know if you could help. Thank you in advance.

 

Employee_IDManager_IDSuperv_HierarchyDesired Outcome
A10110
A25029
A285038
A18047
A856
A4265
A4574
A45683
A25192
A251101
B312613
B15422
B1631
C1618
C18427
C18436
C5252745
C568754
C18463
C189772
C18981
4 REPLIES 4
CharlieS
17 - Castor
17 - Castor

Hello @belouizi 

 

I've attached an example solution that uses the Tile tool to provide that output. Let me know if this works for you.

belouizi
7 - Meteor

Hello @CharlieS 

 

Thank you for the prompt response. is there away to build the same WF without two input because I don't have the desired output column; I just provide it as an example because that's how I want it to look like.

CharlieS
17 - Castor
17 - Castor

Happy to help!

 

The second input is not necessary and was only included to provide a check of the work provided. That's why it's in a separate container labeled "Check Solution". Delete that container and the top line of tools will get the job done as expected.

belouizi
7 - Meteor

Thank you so much. That was very helpful.

Labels