Data Transformation Engine Functions and Expressions Reference Guide

Chapter 1 - Expressions and Evaluations Evaluating Expressions
Functions and Expressions Reference Guide
22
For example, suppose you want to evaluate the following map rule.
NumberSet ( s ) = B:Card2 + A:Card1
In this example, an evaluation set for this rule consists of one value for B and one
value for A. One evaluation set produces one NumberSet.
As an example, here there are three As and three Bs in the data:
A Values B Values
1 3
2 2
3 1
There will be nine evaluation sets. The order of the cards may affect the order of
the evaluation sets.
Case 1: If Card 1 is the first card, you will get the following result:
Evaluation # A B Result
1 1 3 4
2 2 3 5
3 3 3 6
4 1 2 3
5 2 2 4
6 3 2 5
7 1 1 2
8 2 1 3
9 3 1 4