on 08-21-2009 3:49 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.