3 Replies Latest reply: May 8, 2012 12:55 PM by cmcwhi

# Pulling a property from one node to another

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
S12345               NT
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 11.1.2.1.106
• ###### 1. Re: Pulling a property from one node to another
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.
• ###### 2. Re: Pulling a property from one node to another
Hi,

Please use the below formula and change the Hierarchy name and property names accordingly.
---------

If(And(Equals(String,PropValue(Core.Leaf),True),Equals(String,SubString(Abbrev(),0,1),U)),

HierNodePropValue(HIERARCHYNAME,PropValue(Custom.Prop2),Custom.Prop1),

)

---------

Regards,

RK
• ###### 3. Re: Pulling a property from one node to another
Thanks RK. That did it. I appreciate your prompt response.