Add a Field

Once the tables have been added and linked, fields can be added to the Data Model.

1. Click on the to open the Fields.
2. Right-click on the Field to access to these options :

• Add Column,
• Join to Specific Values,
• Remove from Columns.
  
  Note

  Fields that have already been added and joined will be highlighted in blue.

  Fields highlighted in blue with bold black font means they are added but not joined.

  Tip

  Double-clicking on a field will also add the specific field in the list of columns.

Fields can be removed from the Data Model by right-clicking on the Field name and selecting Remove from Columns. It is possible to select multiple Fields by holding the Ctrl key and add them at the same time.

Calculated fields can also be added to a Data Model by selecting Add Calculated Column from the Insert drop-down menu or by clicking on the Add Calculated Column in the tool bar or by right-clicking in the Fields Table Section and selecting Add Calculated Column.

The Fields will always be added at the end of the list.

You can easily re-order them by doing a drag and drop.

The following three buttons in the toolbar can be used to resize the columns.