Mapping Architect for Visio Guide

10.4.0
- 10.5.7
- 10.5.6
- 10.5

Back Next

Using the %ALL% Keyword in an Expression

When you add an expression to a transformation, use the %ALL% keyword in the port name and in the expression. The %ALL% keyword acts as a placeholder for the names of all ports in the transformation. Use the %ALL% keyword if you have a number of ports for which you want to use the same expression. Use a precision of 0 if you want the output ports to have the same precision as the input port from which they are created.

When you use the %ALL% keyword in the port name and expression, Mapping Architect for Visio performs the following tasks:

Creates an output port with the same name for each input port in the transformation.
To avoid duplicate ports in the transformation, use a prefix or suffix with the %ALL% keyword. Mapping Architect for Visio creates output ports with the input port names plus the prefix or suffix.

Sets up the same expression for all output ports.
The datatype that the expression returns becomes the datatype of the output ports.

The following example shows an Aggregator transformation where the %ALL% keyword is used in an aggregate expression. You configure the following properties:

Port Name = AVG_%ALL%_out
Expression = AVG(%ALL%)

The input ports for the transformation have the following names:

PRICE

COST

QTY_ON_HAND

The Aggregator transformation will have the following output ports:

Port Name	Datatype	Expression
AVG_PRICE_out	Decimal	AVG(PRICE)
AVG_COST_out	Decimal	AVG(COST)
AVG_QTY_ON_HAND_out	Decimal	AVG(QTY_ON_HAND)

Rename Saved Search

Table of Contents

Mapping Architect for Visio Guide

Mapping Architect for Visio Guide

Using the %ALL% Keyword in an Expression

Using the %ALL% Keyword in an Expression