Databases Reference
In-Depth Information
Once this has been done, you should end up with a union mapping that looks like the one
displayed in the following screenshot:
Who said spaghetti?
The final step that needs to be done is to add the union's
Target
fields to the
Output
node. Join the
Union
block and the
Output
block, then click on the
Output
block to define
the fields used.
Add
DATA_TYPE
,
CUST_NAME
, and
ORDER_YEAR
as attributes, and
ORDER_AMT
as
a measure.
Once this is done, check if your final calculation view looks like the one displayed in the
following screenshot: