Multple Actions on single Qualified table??

[Former Member]

Hi Experts,

I have a QT with 1 Non qualifier and 2 qualifiers..

My requirement is

Main table

-

---

CC Code (Unique key)

CC Contact info (LK QUAL)

Qual Table

-

---

Type (Non Qualifier)

Telephone (Qualifier)

Fax (Qualifier)

Value in Type Field is

-

---

General

In data manager i have the following..

COde :99

type : General

Telephone: 43

Fax: 11

There are 2 requirments for this table..

if my second file has inputs as..

Code: 99

Type: general

Telephone: 3342424242

fax: 222342

Code: 99

Type: External

Telephone: 24224567

fax: 3432342

Now My record after import should look like..

Code: 99

Type: general

Telephone: 3342424242

fax: 222342

Code: 99

Type: External

Telephone: 24224567

fax: 3432342

So here New External is added(Which is not available in DM in prior) and Old 'General' is replace with new values..

Is this possible???

i tried with Qualified update in Import manager

If i set Update then new values(External) is created but the 'General' is added as a new Entry instead of Updating the old 'General' entry..

If i set Replace/Append then the External values are not being added..

Can any one say whether this is possible & What is ONLY possible??

Please Help..

KR

John

[former_member206388 · Accepted solution]

Hi John.

What fields have you selected in the Matching Qualifiers after clicking "Set Qualified Update" and Click "Update" in the destination field. In your case, you should select "Type" and New Links="Create" and Existing Links="Update(All Mapped Qualifiers)".

Hope this helps.

Regards

Bala

[Former Member · Accepted solution]

Hi,

In the mapping tab..

I selected the Type Filed -> Right click-> set qualified update - > here i selected update-> i can see the telephone and fax moved to the selected qualifiers -> New links Create -> existing link update (all mapped fields).

If i do the above the New entry (Type: External, Tele and fax ) is added, But there is a new entry for Genral(Which should be actually updated with the Old entry of general)

Can anyone help!!

Kind Regards

Venkat

[Former Member · Accepted solution]

Hi John

The settings are done correctly. Which version of MDM you are using?

Thanks-Ravi

[Former Member · Accepted solution]

Hi John,

Since you have kept Telephone and Fax as matching qualifier, if there is a change of telephone for exisiting type say "General", since the incoming telephone doesnt matches the existing one , system generates a new entry for General

Keep the matching qualifier as Type (General/External) only, which will solve your issue

Kindly revert for any queries

Regards,

Antony

[Former Member · Accepted solution]

Hi Antony,

That worked when i removed the telephone and fax as qualifiers.

~Thanks all

KR

John