Concatenation of attribute values

[Former Member]

Hi Friends,

We are on MDM 5.5 SP06 PL04.

We have a requirement where in we have to update a field in the main table based on the attribute values entered by the user in the lookup field [taxonomy] in the same table through the Data Manager..

Say, there are 5 attributes : A1, A2, A3, A4, A5. The value to be updated in the field would be the concatenation of the values entered in the attributes, separated by a space.

None of the attributes are mandatory, though at least one has to be populated.

Is it possible to carry out this requirement through assignments? If not, could you please suggest some alternatives to acheive the same?

Regards,

Anil Madhavan

[Former Member]

Hi,

This requirement can be achieved using Assignment.

Say In record mode, You have a Record in your Main table of MDM data Manager which has a category associated with it.

This category is linked with 5 Attributes say A1, A1, A2, A3, A4, A5.

say A1 has value XYZ

A2 has value ABC

A3 has Value 123

A4 has Value 456

A5 has Value 789

so you want concatenation of all these three Attribute value as: XYZ ABC 123 456 789

Create an Assignment: give the Assignment field where do you want to have this concatenation value populated.

Now right click on this assignment-->Add Branch.

Select the Branch Value of that category: Write Assignment Expression here in this Add Branch Assignment as:

write Assignment Expression as below:

A1&" "&A2&" "&A3&" "&A4&" "&A5

Note: Select the Attributes names from Drop down Attributes tab.

Thanks and Regards,

Mandeep Saini

[Former Member]

Hi Mandeep,

Thanks! That helped me.

However, when a new attribute is added, we would have to come back and modify the Assignment to include the same

It seems that a generic solution that would cater to a dynamic scenario (Addition/Deletion of attributes) is not possible in MDM, at least currently.

Regards,

Anil Madhavan