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

Qualifier lookups

Posted on Nov 19, 2007 at 06:31 AM 20 Views

MDM Experts,

Can you create a lookup inside a qualifier table?

and if so will it allow you to create the compound field?

Thanks

Simona

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 19, 2007 at 03:34 PM
    1

    Hey Simona,

    You can create a lookup inside a Qualified Table for eg. in the SRMMDMCAT repository the Price which is a Qualified Table is having fields like currency which is looking up in Currencies table and if u try u can create one and it will allow to create the compund field.

    Regards Tejas................

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Nov 20, 2007 at 05:16 AM

      Hi simona,

      1.When it comes to qualified tables you have the fields as display fields and the Non Qualifiers .You can only create a compound field if and only if the field is a DF(display field) and NQ(non qualifier)

      2.If a field in a qualified table is a qualifier and display field then you can map it individually but it cannot be a part of a compound field.

      3.If a field is qualifier and not display field then you need to map it individually, and this field is also not part of a compound field.

      4.If a field is non qualifier and not display field the this value has to be entered manually through data manager.

      These are the most important points to be remembered while trying to import data into a qualified table through your main table.

      Reward points if it is helpful

      Best Regards,

      Chinmoy

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 05:22 AM
    1

    Hi,

    yes you can create a lookup in a qualifier table and it allows you to create the compound field.

    For eg.

    In my main table i have two fields productid and MRP(which is a qualifier field).

    In my qualified table i hav MRP, Price and Tax(which is a look up)(Price and tax are non qualifiers).

    In my lookup i just hav the tax field.

    Initially import the lookup flat i.e. tax values .Then import the qualifier table .After this you can import the main table .In this case first map the non qualifiers(including the value mapping) then create the compund field and then map the other fields of main table and then import.

    In this case make the non qualifiers as display fields.

    I hope this helps you.

    Regards

    Nisha

    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.