Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Are you expecting like this !
How do you identify Parent for a Code, do you have a mapping table or Logic?? please explain
Yes, but with the data I have provided. Thanks for the response. I am very new to Qlikview, so could you please adapt such a solution to my data?