Skip to Content
avatar image
Former Member

Updating Qualifiers using import manager

I am having difficulties with updating my data in qualified lookup tables. I have a qualified lookup table Produkt Market Data with market as a display field (hierarchical lookup).

All other fields in this table are qualifiers, most of them multi valued. I have loaded the non multi value fields in the table first, so there is an entry for eg product 4711, market Health Care.

When i try to update a field text (multi valued flat lookup) using the import manager, the record 4711-Health Care is not updated but a lot of entries 4711-Health Care are created extra, each of them containing one line of text. I used the option update all mapped fields (and have mapped only product, market and text). When I choose the option update Null fields only, nothing happens: only the lookup table for the text is updated.

can anyone tell me what i am doing wrong. It should be possible to update qualified fields using the import manager instead of creating new entries shouldn't it??

Regards,

Bert

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 21, 2005 at 05:48 AM

    Hi Bert,

    While mapping the fields in the Map fields/Values tab,

    1. Select the Non-Qualified field in the Destination fields

    2. Right click and select "Set Qualified Update" and then "Update".

    3. In the new pop up, select the matching qualifier.

    4. For New Links, set "Create"

    5. For Existing Links, select "Update Mapped Qualifiers".

    6. Now, in the Match Records tab, select Default Import action as "Update(All Mapped Fields)".

    This should not create duplicate records.

    Hope this helps....Let me know in case you still face problems...

    Regards,

    Rajani Kumar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Subbu! Found this post and it applies to my issue. On my qualified table, I will have up to four entries for a record. There are 3 non-qualifiers A, B, C. A will remain the same and is the same for all four entries. B will all be different for each entry and, once issued will not change. C can be changed. The qualifiers are irrelevant at this point. I will be importing XML files (multi-node) from XI out of PR5.

      I keep getting conflcts. Plus, my "Set Qualified Update" is greyed out. I'm close.. but frustrated

  • avatar image
    Former Member
    Dec 21, 2005 at 03:30 AM

    Hi,

    In the Import manager, Import action for "Exact" Match Type select it as "Replace".

    Let me know if you want with an example.

    Thanks

    Subbu

    Add comment
    10|10000 characters needed characters exceeded