Hi Qlik gurus
I have a employee table:
rank: the level the employee is in the organisation 1 being the top 20 being the lowest without any supervisory responsibilities
id: the employees id (primary key)
id_onedown: the employee direct one down
Sample orignal table and solution needed -->
Original:
rank |
id |
id_onedown |
1 |
123456 |
246824 |
1 |
123456 |
11111 |
2 |
246824 |
369369 |
2 |
246824 |
481216 |
20 |
369369 |
369369 |
20 |
481216 |
481216 |
20 |
11111 |
11111 |
Solution required:
1 |
2 |
20 |
123456 |
246824 |
369369 |
123456 |
246824 |
481216 |
123456 |
|
11111 |
Where I am trying to form a relationship in the load script for all those indirectly under them...
Thanks in advance