Join tables - SmartPlant Foundation - IM Update 46 - Help - Hexagon

SmartPlant Foundation Help

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10
SmartPlant Markup Plus Version
10.0 (2019)
Smart Review Version
2020 (15.0)

You can join two tables to combine data from different tables. You can also define the type of join to limit the records that will be retrieved, depending on how the data sources are related to each other. In addition to this, you can also define the condition to compare values in two tables that have common fields.

If Microsoft Excel file is used as a database, the Join Tables option is unavailable.

  1. In the Tables pane, select a table name, and click Join Tables .

    SHARED Tip This table will be considered the left side of the join.

    If you perform a join between the Assets and Manufacturers tables in the SQL database, you must ensure that the Display As value in the Manufacturers column of both the tables is different.

  2. In the Join Tables dialog box, add a name for the join.

  3. Select a table name from the list that will represent the table on the right side of the join.

  4. Select the type of join from the list.

  5. To define a condition, select a column display name from the first list box, an operator from the second list box, and a column name from the third list box.

    SHARED Tip The first list box displays the column display names of the table in the left side of the join, and the third list box displays the column names of the table in the right side of the join. Typically, the column selected from the first list box represents the primary key, and the one selected in the third list box is the foreign key.

  6. Click OK.