Hi I need to figure out a flow for the following output:
Emp ID | Heirachy IDs |
101 222,534
222 534
534 -
456 001,871,222,534
001 871,222,534
871 222,534
It show heirarchy of managers and employees in an organisation, basically the reporting structure of each employee. I am totally clueless- I need to do this recursively.
The easiest way to achieve this would be to create a recursive Java method in a routine, then use that to produce this output structure. Recursion is not something that is easy to build with a series of components in a job, but you can easily make use of Java to solve this.
