Skip to Content
avatar image
Former Member

Unable to enter NULL value records

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Aug 21, 2009 at 03:18 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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