How to upload data into a cross-referencing table - 6.5

Talend MDM Web User Interface User Guide

EnrichVersion
6.5
EnrichProdName
Talend Data Fabric
Talend MDM Platform
Talend Open Studio for MDM
task
Data Governance
EnrichPlatform
Talend MDM Web UI

You can easily populate the cross-referencing table with data stored locally in a .csv or an .xls file.

Prerequisite(s): The MDM server is already launched. You have been assigned a role with Read & Write access to the appropriate data container, data model and the cross referencing menu.

Note

Make sure that you have selected:

-the data container that holds the master data for which you want to create a cross-referencing table,

-the data model against which the master data will be validated.

For further information, see Accessing data containers and data models.

To upload data into a cross-reference table, complete the following:

  1. Click Cross Referencing in the Menu panel to open a new page.

  2. From the table list, select the cross reference table you want to populate with data.

    The selected table opens on the page and the table name is shown in the field.

  3. Click Upload data file to proceed to the next step.

  4. Browse to the file which contains the data you want to upload.

  5. From the File type list, select the format of the file.

  6. Select the separator and text delimiter used to separate the data stream in the file.

  7. If required, select the appropriate encoding from the Encoding list.

  8. Click on Submit at the bottom of the page.

    A bar displays the progression of the upload operation. The open cross-referencing table is populated with data from the selected file.