Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference PARTITION
Functions and Expressions Reference Guide
163
PACKAGE differs from TEXT because it includes the initiator and terminator of
the input object.
Related Functions
DATETOTEXT, NUMBERTOTEXT, SERIESTOTEXT, TIMETOTEXT, TEXT
PARTITION
The PARTITION function checks to see if an occurrence of an object belongs to a
certain partition. If the object is that partition, TRUE is returned. Otherwise, FALSE
is returned.
Syntax
PARTITION (single-object-expression, single-simple-object-
name)
Meaning
PARTITION (partitioned_object,
simple_name_of_partition_to_check_for)
Returns
This function returns TRUE or FALSE
Returns TRUE if the data object of partitioned_object belongs to the partition
represented by simple_name_of_partition_to_check_for. Otherwise,
PARTITION returns FALSE.
Example
Assume that Transaction has been partitioned into three partitioned
subtypes: Invoice, Order, and Remittance, as shown.
The following rule could be used to detect whether a given Transaction is an
Invoice.
PARTITION (Transaction:.:Batch, Invoice)
If the Transaction is an Invoice, PARTITION returns TRUE. If the
Transaction is not an Invoice (for example, it is an Order or a Remittance),
PARTITION returns FALSE for that Transaction.
Uses
Use
PARTITION to check whether an object belongs to a certain partition.