Unable to enter NULL value records

[Former Member]

Hi experts,

I need to upload a excel sheet data to mdm .

details of name and class.

Name(DF) Class

-

---

Tom one

jane two

dorsan

rudy

tej three

zindal

there are NULL values(Blank) for customers - dorsan, rudy, zindal.

in matching records i selected both name and class then imported the data.

i can see the following in Data manager..

Name(DF) Class

-

---

Tom one

jane two

tej three

zindal

Can any one tell me why only four records are imported?

Regards

Phani

[Former Member · Accepted solution]

HI Phani

In import manager after selecting both the fields Name and Class for matching also combine them. Then try to import the records again, you will get same number of records as in the source file.

Let me know if this resolves the problem.

regards

Ravi

[Former Member · Accepted solution]

Great, that worked.

Can i know the reason why we need to combine while we match them..!!!

Regards

phani

[Former Member · Accepted solution]

Dear Phani

This is required as the combination should be treated as the Unique key for the table otherwise for the entries where we same say NULL values are considered as duplicates by MDM. Selecting both the fields is with OR condition and combining them is with AND condition.

Please close the thread if answered.

best regards

Ravi