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

Qualifier table

Hi SDNers,

I working on qualifirer table and my table details are :

Main Table: Partno,Califor_equiped,A_C_equped,P_B_equiped.

.

Qualifer Table:

Make,Model,Year,Califor_equiped,A_C_equped,P_B_equiped.

In this Califor_equiped,A_C_equped,P_B_equiped are qualifiers and

Make,Model and Year are Non qualifiers.

can anyone provide me step to impot this table without making clone fields of non-qualifires.

Califor_equiped,A_C_equped,P_B_equiped are all depending on same 3 non qualifiers.

Points will be rewarded if found helpful.

Thanks in advance.

Neethu Joy

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2008 at 06:52 AM

    Hi Neethu,

    Go through this weblog:

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

    I m confused abt ur main table fields............ whcih flied is of type Lookup[Qualified Flat]?

    Thanks,

    Maheshwari.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Neethu sorry for late reply,

      In destination side u have to select ur main table.

      Yes it will be greyed if u have mapped any yes qualifier before the above mentioned procedure .My scenario was same as of yours and i have applied the steps i told you.

      like first map only no qualifiers :qualifiers are make,year,model

      then follow the above procedure

      and then map yes qualifiers.

      This will save your time and also u need not to make any clone field there.

      Hope this may help u .for any further problem plz ask

      Regards

      Ankit

  • author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2008 at 08:12 AM

    Hello Neethu,

    you need not to import qualified table first and then data in main table in your scenario ,follow the below steps:

    In Import Manager:

    1) Select the main table in the source field

    2)In the destination fields ,Map the no qualifiers then select the no qualifier and right click u will find options : select Set Qualified Update ,in that select select Update .

    3)In that tab u will find a pop up window "Set Matching Qualifiers " in that select the Yes qualifiers u want from the list given.

    4)In above tab if u are importing for the first time select "Create " and "Update all mapped qualifiers".

    5) After mapping all no qualifiers and selecting "Update" map the other fields and then import the data .

    In data manager u can select ur main table and see that data is populated .

    Hope u find this useful

    Regards

    Ankit.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2008 at 06:22 AM

    Hi Neethu,

    There are basically Two steps for importing the Qualified and non-qualified Values.

    1)Select the Qualified Table on the Destination side it will show you the Non-qualified fields map those first, if there is no such field in the source side create it with any null value.

    Once this has been done import that map only with non-qualified value.

    2)create the new map, Select the main table on the destination side and map all the qualified and non-qualified value and import those but while importing this all the qualified and non qualified values should map with the qualified__nonqualified_fieldname<Qualified_Tablename>respectively

    .

    Hope dis helps you.

    If any doubt feel free to ask.

    Reward points if found useful.

    Swapnil...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2008 at 06:32 AM

    Hi Neethu,

    First open the import manager and select the Qualified table and map the non Qualified fields and import them.

    Then again select the Main or Master table and map the non qualified once again and map the Qualified fields and then create a compound field on Qualified field and then import this mapping.

    You will get the data along with the qualified table and fields.

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

    Edited by: Tejas Bane on Jan 25, 2008 12:03 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2008 at 06:42 AM

    Hi Neethu,

    I also had the same problem regarding the qualified tables, the following thread which i posted explains the detail working of qualified table, you can first work with a simple example and then try your hands on with your actual data.

    Qualified Tables Working

    Hope this solves your problem.

    Reward points idf found helpful..............

    Prasad.....................

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2008 at 06:47 AM

    steps to be followed for importing qualified table in MDM:

    1.First check what are the display fields for the Qualified table in question.

    2.Check if all the Display Fields of the concerned Qualified table are mapped. Select the Qualified Table on the Destination side it will show you the Non-qualified fields, map both the fields as well as the values.

    3.Check if Value mapping was performed for all the display fields which require field mapping. GO in import status tab if ready to import then execute the import.

    4.select the main tables in both destination and source.Right click on the Source fields and create the Compound field for the data if required.

    5.Then map the Compound field to the Qualified Field.

    6.Do the Auto mapping for the compound field.

    7.Go to the import Status tab, you should not get the error now.

    this shud work, award points if found suitable.

    thanx

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 10:01 AM

    Hi Neethu,

    This is Alok not Ankit.

    If i am right, As per my knowledge there is no possibilty to map single source filed with multiple destination fields.

    so either cloning or multiple enteries in source file.

    and you are pretty much right.

    Thanks again

    you have all qualifiers in main table also.

    Main Table: Partno,Califor_equiped,A_C_equped,P_B_equiped and in qualified table also.

    and your question is how to map without cloning these fields.

    just only way to map a source field to two different destination fields is that "Source field must be present 2 times in source structure (file)".

    this can happen in two ways

    1. Either your source file already have these fields 2 times

    2. or you have to clone it in Import Manager.

    and to How to map qualifiers or source to destination is explained alredy in thread.

    Please rewrds if helpful.

    BR,

    Alok Sharma

    Edited by: Alok Sharma on Jan 28, 2008 12:20 PM

    Edited by: Alok Sharma on Jan 28, 2008 12:23 PM

    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.