Query Wizard - Select Sources (Blending Query)

Top  Previous  Next  

 

A blending query allows you to blend data from two or more seperate sources into a single data table

 

clip5863

 

With both the Outer and Inner sections, you can choose to select an Query from the current dashboard, or choose to create a new query. Choosing a new query will run another Query Wizard before returning to this screen.

 

 

clip5865

 

 

You then select the refresh behaviour...

clip5866

Either

Refresh the Query that provides this data when the blending query is refreshed

or

Only Refresh the query that provides this data if there is no data available

 

The second option would be used in cases where the table's data does not change.

 

If you are editing the Query you can choose to 'Clear Data' so that the query is refreshed,.

 

If either the Outer or Inner Table Data is set to another query in then a checkbox is enabled that allows this query to be refreshed if an underlying query is refreshed,

 

clip5864

 




Copyright © 2003-2017 DataPA Limited, all rights reserved. DataPA OpenAnalytics 6.0