Deleting Lookup field value

[Former Member]

Hi Guys

We have a case where we loaded 50,000 main table records against a value in a qaualified look table. We now want to undo this action.

The records were loaded against the Qualifed lookup table with a compound key of 2 non-qualified fields.

We tried:

- Deleting the value in the Qualified Looktable (as its not "linked" to any other records) but cannot because of the relationship to the main table records

- Reloading the customer in questoin but with Null of the compound key. This will not drop the qualified lookup relationsip as we want.

- Deletion from data manager the entry in the Lookup field but this will not allow as mass up data for 50,000 records.

also we do not want the reload and replace these customer as it will mean that well will loss all other data. As in we will have to relaod all data in the all Qualified lookup table for these customers.

Any other suggestion?

Regards

Con

[Former Member · Accepted solution]

In Import Manager Configuraton Options,

<b>Default Qualifed Update</b> value can be set to <b>Replace</b>

Reimport using the same file, but this time choose Update Mapped Values only.

Dont map the fields you want to preserve.

Another option is to use MDM Java API.

You can use CatalogData.DeleteQualifiedLinks

Let me know how you handled this situation.

Ads,

[Former Member · Accepted solution]

Hi ya

I used to first option. Loaded the correct data and set the Default Qualified Update to replace. Result the correct main records and lookup values are loaded, all previous values replaces.

Thank you for the help

Rgs

c