[LOAD SCRIPT] Pivoting of data with relationship hierarchy involve

fishing_weights — Fri, 15 Nov 2024 20:55:14 GMT

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:

Solution required:

Where I am trying to form a relationship in the load script for all those indirectly under them...

Thanks in advance

topic [LOAD SCRIPT] Pivoting of data with relationship hierarchy involve in App Development