How to concatenate attributes?

[Former Member]

There is an algorithm that needs to be incorporated into MDM. The algorithm requires to concatenate all of attributes for each record and put them into another field with space and comma between the attributes. I was only able to get the name of hierarchy using the calculated field.

Is it possible without Java API?

[Former Member]

Paritioning works to concatenate with comma or space as delimiter very well. I have done it on fields of my table, and I also mapped the partitioned source field to the remote key of the destination table.

Hope it works for you

Thanks

Savi

[Former Member]

Yes, I think so!

Good luck!

Savi

[Former Member]

Hi Thomas,

Oh, so are you saying that you cannot use & operator of calculation engine to concatenate attributes? Possibly because, attributes are defined in data manager where as the calculation expressions are defined in the console?

Does not import manager's partition work?

[Former Member]

Hi Savitri,

I think it may work as you said using import manager.

I will try it out.

If it doesn't work, the only option is via Java API. Right?

Thanks