Qualifier table option in import manager.

[Former Member]

Hi Sdners,

I want ot know what is usability of "Set Qualified Update" option in menu bar of import manager.

How to use above mentioned option because when im trying to use it, its greyed out.

Iam using MDM 5.5 SP04.

Explain with below mentioned example.

Main table:

1)Material_number -

---

> Integer

2)Material_description -

---

> Text

3)Region -

---

> LookUpQualified(multivalued).

Qualified Table.

1)Region -

---

> Nonqualifier.

2)Tax -

---

> Nonqualifier.

3)Price -

---

> Qualifier.

Points will be rewarded for genuine answere.

Thanks in Advance.

Regards,

Neethu Joy.

[former_member496675 · Accepted solution]

Neethu,

Here's the scenario where you would use this option.

Suppose you are importing the main table data and qualified table data. The initial load will go fine and you will see correct data in the main table and in the qualified table. However, if you are loading the same data again (somebody made some changes and now the client wants you to re-import the data) then you should be very careful with the qualified data. By default a qualified link is set to 'Append' which means every time you import data (even the same data), import manager will create a new link in the qualified tables. To avoid this, you choose the option 'Update' instead of append. This option will allow you to update the existing links and create new ones ONLY if there is new data for them.

Now about why the option is grayed out. To enable this option you have to right click the field that links the qualified table to the main table. For example, in your example below, the field 'Region' is the link between the qualified table and the main table. Right click on this field to set the import option.

Regards,

T

[Former Member]

Hi Neethu,

"Set Qualified Update Option" is used to populate the qualified table after the main table importing.

The general practise is to populate all the lookup table before populating the main table.But for qualifiers you have na option of populating the Qulaified table after the main table ,to do this we have the "SET QUALIFIED UPDATE" option .

Hope it helped

Reward points if found useful

Thanks & Regards

Simona

Edited by: Simona Pinto on Mar 6, 2008 5:51 PM

[Former Member]

Hi Neethu,

follow the it may help you to solve you query about Set Qualified Update.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/9030396d-0e84-2910-d8ac-f92388f8...

Regards,

Vinay Yadav