Data Transformation Engine Functions and Expressions Reference Guide

Chapter 1 - Expressions and Evaluations Evaluating Expressions

Functions and Expressions Reference Guide

Using IN to De-couple Object Name Coordination

Suppose you have a situation in which you do not want to coordinate common

objects. You may, for example, want to count different objects contained in the

same object, as in:

Summary = COUNTABS ( Header:Order:Message ) + COUNTABS ( Line

Item:Order:Message )

If there are multiple Orders in your data, the Summary would not be evaluated

correctly. This rule would only count the Headers of the first Order and add it to

the count of all Line Items of the first Order. To count all the Headers and all the

Line Items in all the Orders, use IN:

Summary = COUNTABS ( Header IN Message) + COUNTABS ( Line

Item IN Message )

Using IN to De-couple Different Partitions in the Same Rule

If data objects in an expression are different partitions of the same type, the

expression may evaluate to NONE.

For example:

MyMap ( Good<>Design , Best<>Design )

Good and Best are partitions of the same type, Design. A given Design could

never be both a Good<>Design and a Best<>Design; therefore, the second

argument of MyMap, Best<>Design, evaluates to NONE.

To reference both the Good and Best partitions, use IN:

MyMap ( Good IN Design , Best IN Design )