I have a hierarchy that contains many thousands of nodes at various levels of the hierarchy. At the bottom (leaf) are two types of nodes. ‘S’ and ‘U’. The ‘U’ nodes contain a property that is the same as one (and only one) of the ‘S’ nodes. The ‘S’ nodes contain a property (T or NT). I want to derive a property for the ‘U’ nodes that pulls the property from the ‘S’ node in Prop1. At its simplest form, it would look like this:
NODE Prop1 Prop2
U98765 S12345 NT (Pulled from the ‘S’ node in Prop1)
It seems like this should be simple, but it has me stumped. I feel like I’m missing the obvious answer. Any ideas? FYI, we’re using DRM V 220.127.116.11.106
One condition will be node that starts with S.
Then you can have a condition saying it is a leaf and sub-string will be a 5 digit integer.
You do a prop value on such nodes. Hope this helps though I did not write an explicit formula here.
Please use the below formula and change the Hierarchy name and property names accordingly.