Data Transformation Engine Functions and Expressions Reference Guide

Chapter 1 - Expressions and Evaluations Evaluated Expressions Assigned to Output Items

Functions and Expressions Reference Guide

Note Track Places will only have an impact on the sequence of the output when both

the input group object and output group object are defined as Track Places.

However, Track Places will have an impact in situations in which an input defined

with Track Places is referenced by index. For instance, in the above example,

♦ If RunsByInning was defined as Track Places, RunsByInning[2]:BallGame

would have a value of 2 because the value in the second "place" in BallGame

is a 2.

♦ On the other hand, if RunsByInning was defined as Track Content,

RunsByInning[2]:BallGame would have a value of 1 because the second

instance of BallGame with content has a value of 1.

Evaluated Expressions Assigned to Output Items

NONE Assigned to an Output Number

When an output item is defined as a number, its value is determined from the

result of the evaluated expression that is then converted to its output form as

follows:

Output is specified as: Evaluated value Output value

Required 0 0

Required NONE 0

Optional 0 0

Optional NONE NONE

Automatic Item Format Conversions

When an item is assigned an output value, the Map Designer will automatically

convert an item with the same interpretation (either number, text, date, or time)

from one presentation to another. For example, if you want to map an item that is

a number and whose presentation is integer to an item that is also a number but

whose presentation is decimal, the Map Designer will automatically convert it.

The Map Designer fills in missing information in date and time conversions in the

following way:

♦ Dates with a year, but no century. The century will be determined using the

CenturyDerivation map setting.