[LOAD SCRIPT] Pivoting of data with relationship hierarchy involve

[fishing_weights]

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