...
Both Append and Union sub queries allow you to bring together the results from two separate sources and display them together in the one report or chart. Minus and Intersect sub queries only allow the selection of different views, rather than sources.
| Wiki Markup |
|---|
{html}<iframe width="700" height="394" src="https://www.youtube.com/embed/m-cKfySK788?color=white" frameborder="0" allowfullscreen></iframe>{html} |
Advanced Append & Union Sub Queries
...
| Section |
|---|
| Column |
|---|
| 1. In order to create an Advanced Sub Query, rather than a Basic one you need to click on the + button in the Sub Query panel to the left of the Data step to add a Sub Query. 2. You then need to select either Append or Union and set the Style to Advanced 3. Select a Data Source and a View. 4. Click on the Submit link and proceed as normal. You will notice that new data fields have been loaded on the left hand side of the window, corresponding to the view you just selected. |
| Column |
|---|
| 
|
|
See Sub Queries サブクエリー for more information.
...
| Section |
|---|
| Column |
|---|
| 1. In order to create an Advanced Sub Query, rather than a Basic one you need to click on the + button in the Sub Query panel to the left of the Data step to add a Sub Query. 2. You then need to select either Minus or Intersect and set the Style to Advanced 3. Select a View. 4. Click on the Submit link and proceed as normal. You will notice that new data fields have been loaded on the left hand side of the window, corresponding to the view you just selected. |
| Column |
|---|
| 
|
|
See Sub Queries サブクエリー for more information.