Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference EXTRACT
Functions and Expressions Reference Guide
104
EXTRACT
The EXTRACT function returns all members of a series for which a specified
condition is true.
Syntax
EXTRACT (series-object-expression, single-condition-
expression)
Meaning
EXTRACT (objects_to_extract, condition_to_evaluate)
Returns
This function returns a series-object.
The result is each member of series_to_search for which the condition specified
by condition_to_evaluate evaluates to TRUE.
EXTRACT returns NONE, if no
member of series_to_search has a corresponding condition_to_evaluate that
evaluates to TRUE.
Examples
EXTRACT ( PO:Transaction , Store# = Location:PO:Transaction )
This example returns all POs, individually, whose Location is a particular
Store#.
EXTRACT ( Row:DBSelect , ProcessFlag Column:Row:DBSelect =
"Y" )
This example returns all Rows that have a ProcessFlag Column value of "Y".
Uses
Use
EXTRACT whenever you need only particular members of a series
returned—those that meet a certain condition. An example may be only POs
that contain backordered items.
Note The EXTRACT function can only be used in a map rule. It cannot be used in a
component rule.
Related Functions
CHOOSE, LOOKUP, SEARCHDOWN, SEARCHUP