Developer Mapping Guide

Back Next

Example. Expression Parameters in an Expression Transformation

Use an expression parameter to parameterize the port expression in an Expression transformation.

For example, you might want to use an Expression transformation to concatenate data on states and cities.

The following table lists the data that you might transform:

You want to concatenate the data using the expression

CONCAT(CONCAT(City, ','),State)

. In the Expression transformation, configure an output port

Location

and assign an expression parameter to the port expression.

The following image shows the output port

Location

in the Expression transformation:

The following image shows where you can configure the new expression parameter:

The following image shows where the expression parameter appears:

When you run the mapping, the output port uses the expression parameter to write data using the format

City,State

, such as

Sacramento,CA

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.