Data Transformation Engine Functions and Expressions Reference Guide

Chapter 1 - Expressions and Evaluations Data Object Names

Functions and Expressions Reference Guide

Ball Room[LAST]

Really<>Grand<>Ball Room

Ball Room

Indexed Object Names

An object name can refer to a particular occurrence of a data object. The index of

the occurrence appears in square brackets immediately after its name. For

example, the object name of the third Note would be:

Note[3]

The index between the square brackets can be an integer or the reserved word,

LAST (a special index value that refers to the last data object of a particular

series). The index cannot be another object name. To use a variable index, use

the

CHOOSE function.

LAST is interpreted in the context in which it is used.

Using LAST in a Map Rule to Reference an Input

In a map rule, when referencing an input, LAST refers to the very last occurrence

of that input. For example, the last Note of the input Report would have the

name:

Note[LAST]:Report

In this context, all of the input has been validated before map rules are evaluated.

Using LAST in a Component Rule

In a component rule, LAST refers to the last occurrence found. For example, in

the rule:

PO# Field:Order = PO# Field:Order[LAST]

LAST refers to previous occurrence of Order because when this rule is evaluated,

the last known Order is the last one found.

Using LAST in a Map Rule to Reference an Output

In a map rule, when referencing an output, LAST refers to the last built

occurrence of that object. For example, using the same expression:

PO# Field:Order = PO# Field:Order[LAST]