Data Transformation Engine Functions and Expressions Reference Guide

Chapter 1 - Expressions and Evaluations Evaluating Expressions
Functions and Expressions Reference Guide
24
NumberSet[1] = 7
This is Evaluation Set 2:
A Values B Values
1 3
2 2
3 1
NumberSet[2] = 8
This is Evaluation Set 3:
A Values B Values
1 3
2 2
3 1
NumberSet[2] = 9
If your rule looks like
NumberSet ( s ) = SUM ( A:Card1 ) + SUM ( B:Card1 )
there will be only one evaluation set:
A Values B Values
1 3
2 2
3 1
NumberSet[1] = 12
If you have the following rule:
NumberSet ( s ) = A:Card1 + EXTRACT ( B:Card2 , B:Card2 != 2
)
the order of the operands does not affect the order of evaluation set selected. This
is because an A is selected, then the
EXTRACT is evaluated, then evaluation sets