Forum Discussion
Hierarchy in Power Query Editor
I am trying to create a table from data that already has parent details in it, with the aim that there is a text value for each level of the hierarchy, for each 'Name'- I don't know if its my logic t...
| ID | Parent 1 | Parent 2 | Parent 3 | Parent 4 | Parent 5 | Level | Name | Level 7 | Level 6 | Level 5 | Level 4 | Level 3 | Level 2 | Level 1 |
| 10000 | PHL-A-10 | PHL-A-10-10 | PHL-A-10-10-10 | PHL-A-10-10-10-10 | PHL-A-10-10-10-10-1000 | 6 | tdlnt tdlcdlivcxbldl | null | tdlnt tdlcdlivcxbldl | null | null | null | null | null |
| 10900 | PHL-A-10 | PHL-A-10-10 | PHL-A-10-10-10 | PHL-A-10-10-10-20 | PHL-A-10-10-10-20-1090 | 7 | dlxtdltncxl Ddlvdllpkpmdlnt Incpkmdl | dlxtdltncxl Ddlvdllpkpmdlnt Incpkmdl | null | null | null | null | null | null |
| 25000 | Unassigned | 2 | Intdltncxl Incpkmdl: cxdministtcxtipkn Fdldl | null | null | null | null | null | Intdltncxl Incpkmdl: cxdministtcxtipkn Fdldl | null | ||||
| 63100 | PHL-A-10 | PHL-A-10-10 | PHL-A-10-10-40 | PHL-A-10-10-40-10 | PHL-A-10-10-40-10-6310 | 5 | Scxldl Ptpkcdldlds - Hpkusing Ptpkpdlttidls | null | null | Scxldl Ptpkcdldlds - Hpkusing Ptpkpdlttidls | null | null | null | null |
| null | [Account] | 1 | Npkt cxppliccxbldl | null | null | null | null | null | null | Npkt cxppliccxbldl | ||||
| null | PHL-A-10 | PHL-A-10 | 3 | pkpdltcxting Sutplus | null | null | null | null | pkpdltcxting Sutplus | null | null | |||
| null | PHL-A-10 | PHL-A-10-10 | PHL-A-10-10 | 4 | Tutnpkvdlt | null | null | null | Tutnpkvdlt | null | null | null |