on 10-29-2010 1:31 PM
Hi all!
I want to load the Data of the Table with tuple(multi-valued) records in Repository using Excel file. How can i do this? And what is the structure should my source table has?
That is structure of destination table:
FieldName - Type
_________________
GID - Text
BeginDate - Lookup (Flat)
AccountName - Text
AccountType - Boolean
EndDate - Lookup (Flat)
Analytics - Tuple (multi-valued)
That is structure of tuple:
FieldName - Type
______________________
Analytics - Lookup(Flat)
BeginDate - Lookup(Flat)
BEndDate - Lookup(Flat)
Thanks in advance for your comments.
Hi, Serjinyu
You have two options for to load Tuple values from Excel across Import Manager
1 - Create a sheet in Excel with the data of main table and data of tuple. When your tuple value have many values, you need repeat for each tuple value the main table values.
2 - Create two sheets. In the first, put the main table data. In the second sheet, put the tuple values and one column with key value of main table. Open your Import Manager and load the first sheet and import to MDM. After, load second sheet and use key value as Matching to import.
Regards
Vassoler
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.