Skip to Content
author's profile photo
Former Member

How to concatenate attributes?

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?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • author's profile photo
    Former Member
    Sep 29, 2005 at 03:49 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo
    Former Member
    Sep 29, 2005 at 04:15 PM

    Yes, I think so!

    Good luck!

    Savi

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 29, 2005 at 05:53 PM

    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

    Add comment
    10|10000 characters needed characters exceeded