Hello Alteryx Community,
I need your expertise and guidance! I'm currently trying to convert a table to a hierarchical format. My dataset consists of items, parents, and other attributes(please see the table below)
I want to flatten it so that it is easy to see and identify the relationships between items. The output format doesn't matter much to me as long as I can quickly identify the hierarchy. I tried creating an output similar to either of the outputs below.
| Level 1 | Level 2 | Level 3 |
| A | | |
| | B | |
| | | E |
| | | F |
| | C | |
| | | G |
| | D | |
or
| Level 1 | Level 2 | Level 3 |
| A | | |
| A | B | |
| A | B | E |
| A | B | F |
| A | C | |
| A | C | G |
| A | D | |
I tried using macros to iterate over the whole dataset but failed miserably. Honestly, I don't think my logic was sound, hence why I'm not going to provide it here. Please help me.
Note: I don't know how many levels my data has as I have thousands of rows but it's definitely more than 10.
