Define a Source Query - Intergraph Smart Electrical - 10 - Help - Intergraph Process, Power & Marine Documentation

Intergraph Smart Electrical Import Manager Help

Intergraph Smart Electrical
Search by Category
Smart Electrical Version

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. Do one of the following:

    • Click File > New > Query.

    • Right-click the Queries folder and then click New Query on the shortcut menu.

  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. Click Next.

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

    SHARED Tip You can click PPM All Outputs Graphic to select and move all the source tables to the Selected tables list.

  6. Click Next.

  7. On the Define the Relationships Between Tables page, click 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. Click Add to define another relationship or click Next.

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