Skip to Content
author's profile photo Former Member
Former Member

Concatenation in Import manager(MDM)

Hi ALL ,

I want to concat or merge my 3 fields of my Qualified table during Import manager and then map it to one field in my destination table .Please help me in that .

Ex.Name /Country/City into a destination field Info

Thanks and Regards.

Ankit Jain

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2007 at 09:41 AM

    hi ankit,

    If there is only one non-qualifier in a scenario, then the Compound field is not created and direct one to one mappings suffice.

    If in your qualified table, you have more than one Non-qualifier, then only in Import manager, you will find Compound filed active.

    hope this may help you,

    Regards

    srinivas

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2007 at 07:56 AM

    Hi ankit,

    create a compound filed, for name and country, and by using this compound filed and city make another compound filed.

    The resultant compound field is having three fileds. and map this to destination field.

    Hope this may help you,

    Regards

    srinivas

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Ankit,

      an alternative would be using the "Partition Field/Value" tab. Therefore you need to select the first field, then switch to the tab. Now you'll see a field list ("Source PArtition -> Available Fields") where you can choose and add your other fields. Then mark all fields in the "Partition by" column and click on "Combine". Note that you can define a delimiter for combining. IM will create a new combined field for you that you can use in mapping.

      BR Michael

  • author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2007 at 10:14 AM

    hi,

    go through this blog, it will help you,

    /people/pooja.khandelwal2/blog/2006/03/29/taming-the-animal--qualified-tables

    hope this may help you,

    regards,

    srinivas

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2007 at 11:42 AM

    Hi ankit,

    If you create a compound field, automatically it will mapped to a corresponding Destination field.

    --> in the source fields you slect one filed (price) and right click, in the context menu you select compound field( sales data ), the newly created compound field will be automatically mapped to Price field in the destination.

    hope this may help you.

    Regards

    srinivas

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2007 at 04:38 AM

    Hi ankit,

    The requirement that you have to merge three fields together in the Import manager can be done by methods.

    1)Compound field creation

    2)Partioning

    1)Compound field:

    A compound field will only be created if you map all the exsisting fields in the source side with the fields in the destination side.

    For qualified table mapping this is the requirement that if you want to create a compound field you must make sure that all the fields are mapped in the source side.Then when you right click on the non qualifier it will create a compound field and automatically map it with the required field.

    2)Partitioning:

    You can also use partitioning to merge three fields together.

    just click the desired field in the source hierarchy and click the partioning button in that dialog box select all the fields that you want to club under one field.

    Regards

    Simona

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.