Supervisory Level Top Down

[belouizi]

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_ID	Manager_ID	Superv_Hierarchy	Desired Outcome
A	10	1	10
A	250	2	9
A	2850	3	8
A	180	4	7
A	8	5	6
A	42	6	5
A	45	7	4
A	456	8	3
A	251	9	2
A	251	10	1
B	3126	1	3
B	154	2	2
B	16	3	1
C	16	1	8
C	184	2	7
C	184	3	6
C	52527	4	5
C	5687	5	4
C	184	6	3
C	1897	7	2
C	189	8	1

[CharlieS]

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]

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 · Accepted solution]

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 · Accepted solution]

Thank you so much. That was very helpful.