ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Employee Hierarchy

vaibhav_jain
8 - Asteroid
‎09-05-2017 11:10 PM

Hi, 

 

PFA sample workflow having sample input & output. Tried building the workflow using Crosstab, formula tool but the desired result is not coming.

 

Can anyone guide.

Sample_workflow_output.yxzp
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
pcatterson
11 - Bolide
‎09-06-2017 03:41 AM

Capture.PNG

From your initial data, I am to understand the hypothetical hierarchy should look like this.  From my workflow (in version 11.3) you can follow a logic to obtain a hierarchical structure with a max number of 6 levels.  For more levels, extend the joins to encompass them.  I was unsure how you wanted to connect the employees to their 'band'.

SnL.yxmd
Reply
Labels
Top Solution Authors
View All