Data Transformation Engine Type Designer Reference Guide

Chapter 8 - Components Defining Component Rules
See Chapter 8 in the Introduction to the Design Studio for a list of non-
printable Hex and decimal values.
Inserting Functions into Component Rules
You can use most of the functions in a component rule. Component rules in the
examples previously shown use the functions
COUNT, PRESENT, SUM, and WHEN.
Note The function WHEN is similar to the function IF. However, WHEN evaluates to True
or False. IF evaluates to a data object. WHEN is most often used in a component
rule.
To insert a function into a component rule
1 Select the cell in which you want to insert the component rule.
2 Click in the edit window where you want to insert the function.
3 From the Component menu, choose Insert Function.
Or, click with the right mouse button and choose Insert Functions from the
context menu.
Or, place your cursor in the component edit window and press Insert on your
keyboard.