How to create 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

From Talend MDM Web User Interface, you can create one or multiple tables to cross reference master data.

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 create a cross-referencing table, complete the following:

  1. On the Menu panel, click on Govern - Cross Referencing to open a new page.

  2. Click on New cross-referencing table to proceed to the next step.

  3. In the Table name field, enter a name for the cross-referencing table you want to create.

    In the first field, enter a name for the first column in your table.

    Click Add a field at the bottom of the page to add a second field to the page and then enter a name for the second column in your table.

    Repeat the operation to add as many columns to the cross-referencing table as required.

    Select the Key check box next to the column name you want to use as a key column.

  4. Click Save at the bottom of the page to save the table and proceed to the next step.

    A table including all the defined columns will be displayed.

  5. The cross-reference table is now ready to be populated with data:

    Click Add row to populate the table with as many rows as needed.

  6. Enter required data in the corresponding columns and click on Save to save your changes.

    A confirmation message pops up.

  7. Click OK to close the message.

    The populated table is saved and added to the list of existing cross-reference tables.

Note

You can populate the table with data from a .csv or an .xls file if you use the Upload data file option. For further information, see the following section.