Joining Queries

After you have created more than one query, you can join queries to create a new query in the Spotfire Metrics Modeler.

Join queries to combine matching data from two different data sources. Select the first and second queries, and then specify the common columns from the drop-down lists.

Perform this task in the Queries tab.

Procedure

  1. Click Add Query.
  2. Click Join Existing Queries.
  3. Select the first and second queries.
  4. From the Common Columns drop-down list, select the columns that the two queries have in common.
    Note: If you have a constraint, you can only have one column.
  5. Click Preview to review the details, and then click Save.