Hello @community members,
I am encountering an issue while attempting to export hierarchical data to downstream systems and would appreciate any assistance.
Current Scenario:
I have a hierarchy consisting of 6 levels(A0, A1, A2, A3, A4, A5, A6). Upto the A3 level hierarchy is well defined. However for A3 level I have 100 list items, and only 3 of these have assigned children. Similarly, at A4 level, there are 3 list items, of which only 2 have assigned children from the preceding level.
Required:
My objective is to ensure that, at each level of the hierarchy, if any child items are assigned I need to identify immediate parent of each child. If there are no assigned children for a particular parent, I still require the items from the parent level to be included in the single line item for the export. Also, all these levels should be exported into a single file.
When using Parent function, it returns only the immediate parents for each child, omitting other unassigned parent items, Similarly the Item function provides only items from the current level and does not address this requirement.
Could someone please advice on how to achieve this? I have attached screenshots illustrating both the current situation and the desired outcome for reference.
Thanks in advance for your support.
