I have a list in which there are parent and child relationships defined. Ideally, these should have been created within a composite hierarchy but at this stage I am not considering redesigning the lists.
Is there a function whereby I can reference one of these parent items?
Example - Shoreditch, Westminster, Clapham are parents of London
LOOKUP does not work as it only operates on composite hierarchies.
Got it.
You'll want to read @DavidSmith's best practice post on ragged lists.
Rather than me reproducing it here, the summary is that you can flatten the list so you can utilize the Item / Parent.
@DavidSmith also has some suggestions on how to treat Parents. It's an amazing article. Let us know if that is closer to what you needed.
Or, as @CommunityMember115881 suggested, give us a little more detail on what you're trying to do.
My hunch is that you just need to use a system module rather than use a list. You can even populate the system module with the parent from the ragged list.
Anxious to hear more.
I'm sorry but I still have no idea of what it is you're trying to achieve. If you attach some print screens I'd be more than happy to help.
I suppose I could see what bothers you.
Perhaps, it occurs like below with one list item that has a hierarchy in it.
Once I tried to solve this with some tricks, but after all, I got to know regularized hierarchy is the best.
Sorry, I don't have a good answer.
I am watching how this discussion goes, too.
Regards,
Taichi.
Thanks Amaya for the explanation.
So I've managed to solve it using Time for sequential calculation.
Warning, it aint pretty but it does work.
The idea is simply to SUM then LOOKUP using one list member per parent.
If you look at my print screens, the result is simply summing the values as per the last column. Then LOOKUP on it.
The trick is to automatically get one list member per parent.
Let me know if you need more explanation for each line item calculation.
Cheers