Loading tuple multi-valued via Import Manager

[Former Member]

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.

[Former Member]

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