Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference INDEXABS
Functions and Expressions Reference Guide
129
INDEXABS
The INDEXABS function returns an integer that represents the index of an object
relative to its nearest contained object, counting both valid and invalid instances
of the object.
Syntax
INDEXABS (single-object-name)
Meaning
INDEXABS (object_for_which_to_get_index)
Returns
This function returns a single-integer.
INDEXABS returns an integer that represents the absolute index of
object_for_which_to_get_index. The integer indicates the instance this object
that is in the set of all instances of the object, including both valid and invalid
occurrences. Returns 0 if the input argument is NONE.
! If object_for_which_to_get_index is an input, this will be the index within
all members of the series, including valid objects, invalid objects, and
existing NONEs.
! If object_for_which_to_get_index is an output, this will be the index within
all existing members of the series, including existing NONEs.
Note The difference between INDEXABS and INDEX is that INDEXABS counts both
valid and invalid instances, as well as existing NONEs, whereas INDEX counts
only valid instances.
Example
INDEXABS (Message Record:Order:PO_File)
For this example, that Order contains the following Messages:
Message Record[1] Valid
Message Record[2] Error
Message Record[3] Valid