How to find direct reporting manager given a path of hierarchy
Dear Team,
I have a csv file that contains empid, empname, manager1name (CEO), manager2name(VP), manager3name(Senior Manager), manger4name and so on upto manager8name. The direct reporting manager will be the last manager in the row.
Any quick qlik sense code to find out the direct reporting manager id given all employees have a row in the file.
