Open topic with navigation

Create an Append Query

Steps

1. Access the Design workspace.

2. In the page heading, select the drop-down list box, and then select Append Query.

   The Append Query - Target Source window appears.

   

3. In the Families list, select the target family or the family to which you want to append records, and then select Add.

   The Target Source link appears in the page heading. You can select this link to modify the target family.

   The Conditions section is updated to include the following rows:

   • Field
   • Alias
   • Table
   • Sort
   • Sort Index
   • Append To
   • Criteria
   • Or

   

4. Add one or more sources to the design canvas, and then add one or more fields from those sources to the grid in the Conditions section.

5. For the fields that contain records that you want to append to fields in the target family, in the Append To cells, in the drop-down lists, select the desired fields in the target family. In the Criteria cells, create expressions to specify criteria. Any record that meets the specified criteria will be appended to the specified field in the target family.

6. To run the query, in the page heading, select . Confirm that it returns the appropriate results, and then save the query.

Copyright © 2018 General Electric Company. All rights reserved.