Define a Source Query - Intergraph Smart Electrical - Help - Hexagon

Intergraph Smart Electrical Import Manager

Language
English
Product
Intergraph Smart Electrical
Search by Category
Help
Smart Electrical Version
2019 (9.0)

You use this option to define a simple source query. You can use this query to define an import source that combines various tables belonging to a selected source database or various files of the same type (.txt, .csv, and so forth). You select any number of tables in the selected source database and then define the relationships between selected tables. You can then use the defined query when creating a link. You use the Source Query Wizard to define a source query.

  1. Select File > New > Query.

  2. In the Source Query Wizard, on the Define the Query Name and Description page, under Query, type the query name.

  3. Under Description, type a brief description of the query if needed.

  4. Select Next.

  5. On the Select the Source Tables page, from the Source tables list, select a table and select PPM All Outputs Graphic to move it to the Selected tables list. You can select PPM All Outputs Graphic to select and move all the source tables to the Selected tables list.

  6. Select Next.

  7. On the Define the Relationships Between Tables page, select Add.

  8. To define the relationships between the tables, from the Left Table and Right Table lists, select the tables that you want to join.

  9. From the Left Column and Right Column lists, select the columns that correspond to common or compatible data in both left and right tables.

  10. Select Add to define another relationship or select Next.

  11. On the Completing the Source Query Wizard - Query Results page, examine the query results and select Finish when done.