Merge

[Former Member]

Dear Experts,

I would like to know how to merge qualified table data, because when I merge 2 vendors data (interactively) only the main table data are merged but the qualified table data comes only from 1 vendor.

Regards,

John

[Former Member · Accepted solution]

Hi John,

Matching and merging alwars works on main table records. If two fields are like this:

EmpId EmpName Department

00001 ABCDEF SAP

00001 ABCDEF ORACLE

and consider Department as qualified table field.

Now if you will merge these records in Data manager with option Set all (Equal or null) then in mereged record the data will be:

EmpId EnpName Deparment

00001 ABCDEF (for this field DM will ask to choose one value manually from two values SAP and ORACLE resp.)

so you can choose what you want in final record.

Q: How you will merge duplicates in Qualified?

Ans: Couple of options:

1. Delete duplicates manually by selecting qualified table records on some search criteria.

2. while importing data in QT, you can restrict in Import Manager.

Hope it will help you.

Rewards if found helpful.

BR,

Alok