Forum Discussion
Parent Child Hierarchy Problem
Can you please show what your employee data looks like before duplicates are removed or other changes are made? How are the assigments of Dept 01, 02, 03, etc created? Is there a reason why you need to have the department hierarchy and employee data on the same Power Query table as opposed to having two table that are related in the data model?
jennratten Thanks for your message. The file that i am working with already combined the information from two tables into one. As the department table is associated via the employee id, and I would have to remove the employee id duplicate, it would lead to the same problem. To see the original data, please refer to the file which I have uploaded in my personal Drive, the underlying data is also there. Appreaciate your support!