Local results are a snapshot of a Results section shown in topic format. They are used to add the results of one query to another in an Interactive Reporting document file.
To use local results, click anywhere in the Catalog pane and select Local Results on the shortcut menu.
A Table catalog named Local Results is added to the Catalog pane.
To append results from two different Result sets into one single section:
Verify that each of the queries are in two different query sections.
The above step is applicable whether the queries are based on the same or different databases.
In each of the results section, create a computed column with the values 'A' and 'B' respectively (one per section). These values provides you with a column to join on that will never match.
Build a new query with the two local results and use the join type of 'Outer' on these computed columns.
Use all columns from both results sections.
Once you have all the results back, create the “original' columns in your final results section by using a decode logic.
For example, you might use: if (resultsa.column1!=null) {resultsa.column1} else {resultsb.column1}