Create replace value in import manager

[Former Member]

Hi,

I need some basic information about the record maintained in import manager .

Suppose i have two vendors

Vendor name bank account Duns number

V1 123 XYZ

V2 456 XYZ

I have created V2 vendor which have same duns number as vendor V1.

At the import manager level now

MDM expert will have option skip ,create, update nulls ,update all, replace.

As per my understanding V1 and V2 are same vendor created two time so

suppose if i select option

(1) create :- dsuplicate record will be there in my system.

(2) update null:- only null values of V1 will be updated by V2

(3) <b>update all what i assume V1 and V2 both vendor name will be there in the vendor name field</b>

(4)replace v2 values will replace all V1 values.

I would like to know if i select update

the V1 and V2 both filed values will be there in the vendor name field or only V1 or V2. and for all unique values.

and will i be able to maintain both the bank account in the same.

Thansk in much advance

Rohit

[Former Member]

Hi Rohit,

I will take ur example and explain now about the import process :

V1 123 XYZ

V2 456 XYZ

• The complete Import process is based on the Matching field under Match records tab.

• As per your example if you choose Vendor Number as Matching field at any point of time the above records wont get merged to each other.

• Now will explain the import actions:

Skip --> Skip this source record during import processing.

Replace -> Replace this destination record by first deleting it and then creating a new destination record based on the source record.

Update (All Mapped Fields)--> Update the matching existing destination record(s) with all of the mapped fields of this source record.

Create--> Create a new destination record based on this source record.

Hope this clarifies...

thanks

Alexander

P.S.Kindly reward the points, if found problem solved.

[Former Member]

Hi Alex,

Suppose, I have selected XYZ as my matching field,

Then V1 and V2 will be reflected in vendor name as single and both the bank account 123 and 456 will be reflected in the record.

I understood if matching record is same for both the records then if i select update then in the final record i will get single record V1 and V2 will be V1 V2 and 123,456 will be there in single record.

Thanks,

Rohit