Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions

Transformation Language Reference

Transformation Language Reference

ANY

ANY

Returns any row in the selected port. Optionally, you can apply a filter to limit the rows the Data Integration Service reads. You can nest only one other aggregate function within ANY.

Syntax

ANY(
value
[,
filter_condition
] )
The following table describes the arguments for this function:
Argument
Required/
Optional
Description
value
Required
Any data type except Binary. Passes the values for which you want to return any row. You can enter any valid transformation expression.
filter_condition
Optional
Limits the rows in the search. The filter condition must be a numeric value or evaluate to TRUE, FALSE, or NULL. You can enter any valid transformation expression.

Return Value

Any row in a port. Returns a different row each time.
NULL if all values passed to the function are NULL, or if no rows are selected. For example, the filter condition evaluates to FALSE or NULL for all rows.

Example

The following expression returns any row in the ITEM_NAME port with a price greater than $10.00:
ANY( ITEM_NAME, ITEM_PRICE > 10 )
ITEM_NAME
ITEM_PRICE
Flashlight
35.00
Navigation Compass
8.05
Regulator System
150.00
Flashlight
29.00
Depth/Pressure Gauge
88.00
Vest
31.00
RETURN VALUE:
Flashlight

ANY and Complex Data Types

You can use ANY to return a row in a complex port of type array or struct.
For example, you have the following array:
emp_phones = [205-128-6478, 722-515-2889] [107-081-0961, 718-051-8116] [344-894-6463, 861-411-8361] [107-031-0961, NULL]
You can use the following expression to return any row in the array port:
ANY( emp_phones )
RETURN VALUE
: [205-128-6478, 722-515-2889]

0 COMMENTS

We’d like to hear from you!