Hello Folks,
I am looking for a way to concatenate multiple attributes from multiple nest and use that value to populate a simple attribute.
For example consider that I have an entity - HCP, entity - Location, relation - HCP to Location.
A single HCP can be related to multiple Locations. We are pulling some attributes of Location(State & Country) inside HCP as reference attributes in a nest called Address.
An attribute in HCP, say Notes should contain the concatenated values of State, Country from all Locations that the HCP is associated with.
HCP 1 ---------------> Location 1 (State - California, Country - US)
HCP 1 ---------------> Location 2 (State - Texas, Country - US)
HCP 1's Notes attribute should contain the value - California, US + Texas, US

I am trying to see if any of the Out of the BOX cleanser will work and if I can avoid the of use LCA.
------------------------------
Aditya Somayajula
------------------------------