This dialog enables you to make a more precise selection of the source data by selecting the required source tables to be merged into the target domain.
To access this dialog, on the Select Items dialog, select Advanced.
Filter
Use one of these options to filter the data displayed in the data window.
All
Select this option to display all the available source tables.
Selected
Select this option to display only the selected source tables.
Per domain
Select this option to display the source tables that contain data on the domain level only.
Per <plant>
Select this option to display the source tables that contain data on the plant level only.
Per <area>
Select this option to display the source tables that contain data on the area level only.
Per <unit>
Select this option to display the source tables that contain data on the unit level only.
Sort
Select the required option to sort the data according to the table names or according to the order in which the data is merged.
(Data Window)
The data window holds all the source tables available for selection and the merge action selection.
Table Name
This column holds all the source table names. The software displays the selected tables in red.
Select
Select the check box to include the data in the table for merging. The software merges the data using the merge mode (insert / update, or delete) in accordance with the settings you specified.
Hierarchy Level
This column displays the plant hierarchy level for the selected table: Plant, Area, or Unit.
Insert Only
Select this check box to insert the source rows of the selected table. If you specify an insertion condition in the Condition field, the source data is inserted only if it fulfills the condition.
Condition
Type the required insertion condition for the source table for which data columns are to be inserted during the merging process. The software inserts only the source rows of the selected table that comply with the insertion condition.
Select all
Select this check box to select all the source tables for merging (with merge action All). Clear to enable selection of a single table only.
Reference Tables
Selects appropriate reference tables to include with the tables that you already selected in the data window for merging.
Search
Opens a search pop-up window where you can type in a table name to search for. The table name is then highlighted in the data window.
Data Types
Opens the Data Type Selection dialog where you can make the wiring and drawing selection from the source domain.