Databases Reference
In-Depth Information
In order to do this, add a
Union
block to the view, above the two
Projection
blocks, and join
them. This is done, again, by drawing a line from the upper junction of the projection nodes to
the lower junction point of the output node, as shown in the following screenshot:
Now that we have a
Union
block, we need to make the different fields from the underlying
analytic views point to the correct output fields.
Click on the
Union
block, and you will see a list of all the available fields, from both projections.
Add the following fields to the target from the projection that contains the
Real
data (usually
called
Projection_1
) by right-clicking on each field in turn and selecting
Add to target
:
Ê
DATA_TYPE
Ê
ORDER_YEAR
Ê
ORDER_AMT
Ê
CUST_NAME
In order to join the data from the "projected data" view, we need to map its fields to those of the
"real data" view—this is done by right-clicking on the field and selecting
Map to Target
, then by
selecting the appropriate output column. We need to make the following column mappings in
our view:
Ê
DATA_TYPE
maps to
DATA_TYPE
Ê
CUST_NAME
maps to
CUST_NAME
Ê
PROJECTED_SALES
maps to
ORDER_AMT
Ê
NEXT_YEAR
maps to
ORDER_YEAR