Input Table:
| Code | Series |
|---|
| 1.01 | 1.01 Metric 1.01 |
| 1.02 | 1.02 Metric 1.02 |
A.01.01.01 | 1. Number 1 |
| 1.03 | 1.03 Metric 1.03 |
| 1.04 | 1.04 Metric 1.04 |
| 1.05 | 1.05 Metric 1.05 |
| A.01.01.02 | 2. Number 2 |
| A.01.01 | A. Category A |
| 1.17 | 1.17 Metric 1.17 |
| A.01.02.01 | 1. Number 1 |
| 1.18 | 1.18 Metric 1.18 |
| 1.19 | 1.19 Metric 1.19 |
| 1.2 | 1.20 Metric 1.20 |
| 1.21 | 1.21 Metric 1.21 |
| A.01.02.02 | 2. Number 2 |
| A.01.02 | B. Category B |
| A.01 | Pillar 1 |
Hi,
I have data that looks like the table above and I'm trying to build a hierarchy within the load script.
I assume I'd have to come up with a column such as the one below to link to the parent and then use the Hierarchy() function.
Can someone please help me out with doing this with a load script? The data order and format will be as shown in the table above and the one below is the output I'd feed into Hierarchy().
I would appreciate any help on making this output table, as shown below.
Output Table:
| Code | Series | Parent |
|---|
| 1.01 | 1.01 Metric 1.01 | A.01.01.01 |
| 1.02 | 1.02 Metric 1.02 | A.01.01.01 |
A.01.01.01 | 1. Number 1 | A.01.01 |
| 1.03 | 1.03 Metric 1.03 | A.01.01.02 |
| 1.04 | 1.04 Metric 1.04 | A.01.01.02 |
| 1.05 | 1.05 Metric 1.05 | A.01.01.02 |
| A.01.01.02 | 2. Number 2 | A.01.01 |
| A.01.01 | A. Category A | A.01 |
| 1.17 | 1.17 Metric 1.17 | A.01.02.01 |
| A.01.02.01 | 1. Number 1 | A.01.02 |
| 1.18 | 1.18 Metric 1.18 | A.01.02.02 |
| 1.19 | 1.19 Metric 1.19 | A.01.02.02 |
| 1.2 | 1.20 Metric 1.20 | A.01.02.02 |
| 1.21 | 1.21 Metric 1.21 | A.01.02.02 |
| A.01.02.02 | 2. Number 2 | A.01.02 |
| A.01.02 | B. Category B | A.01 |
| A.01 | Pillar 1 | - |
Thanks!
