Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Dragging Tables to Create Tables

When creating a table in a model, it is possible to drag the table from one schema to another schema within the tree.

  1. Click on a table and drag it into the chosen schema in the tree. In the example below, we will drag table dim_customer from Version 1 into Version 2, thus creating a copy of the dim_customer table.
    Image Added
  2. Complete the following:
    • Enter the Table name.
    • Select a Schema from the drop-down list.
    • Select Table type checkbox.
      Image Added
      Click OK.
  3. The dim_customer table has now been copied into Version 2:
    Image Added
Note
titleNote

It is possible to drag more than one table at a time, as long as the tables are within the same schema in the tree.

Image Added

Dragging Columns to Add Columns

When adding a column to a table in the tree, it is possible to drag the column from one table to another table in the tree.

  1. Click on a column and drag it into the other table in the tree.
    Image Added
  2. The following dialog will ask you to confirm the addition of the selected column.
    Image Added
  3. Click OK.
    The column has been added to the destination table.
    Image Added
    Note
    titleNote

    It is possible to drag more than one column at a time, as long as the columns are within the same table in the source system tree.

    Image Added

Dragging Tables into a Group

To create a group, refer to Groups for details.
To drag tables into the group, select the tables and drag them into the group in the tree.
Image Added 
A copy of each selected table is added to the group.
Image Added