› Use Transformation Designer › Manage tables › Table models › Work with table models

Work with table models

Use the procedure in this topic to manage table models.

Before you begin

Before you can manage table models, verify the required global columns and user-defined columns needed for this table model are available.

Procedure

  1. On the Project tab, in the Configuration group, select Project Settings Project Settings icon.
  2. Select the Tables tab to view the table settings.
  3. Depending on your requirements, do one of the following:

    Action

    Steps

    Add a table model

    1. In the Table Models group, select Add New Table Model Add New Table Model icon.

    2. Enter a name for the new table model into the field and select OK.

      The new table model is added to the list of table models.

    3. Double-click the new table model.

      The Properties of Table Model window is displayed.

    4. Select the columns you want in your table model and select Assign Assign button to assign them to your table model.

      You can also rearrange the order of the columns in your table using the Move Up and Move Down buttons.

    5. Clear the Visible setting for any columns that you want to hide in the table during validation. Each column in the table model is automatically visible during validation, with the exception of the "Match Remark."

    Modify a table model

    1. In the Table Models group, select the table model to modify.

    2. Select Edit Table Model Properties.

      The Edit Table model Properties window is displayed.

    3. Assign Assign button, Unassign Unassign button, or rearrange the order of the table columns as needed.

    Rename a table model

    1. In the Table Models group, select the name of the table model to rename.

    2. Provide a new name and press Enter.

    Delete a table model

    1. In the Table Models group, select the table model to delete.

    2. Select Delete Selected Table Model Delete Table Model icon.

      When prompted, select Yes to confirm deletion.

  4. Select Close to save the table model.
  5. Optional. Select OK to close the Project Settings window.
  6. Save the changes to your project.