AREAS function

This topic describes the formula syntax and usage of the AREAS function in the Data Quality Execute Formula transform.

Description

Returns the number of areas in a reference. An area is a range of fields or a single field in a record.

Syntax

Areas(reference)

The Areas function syntax has the following argument:

  • reference A reference to a field or a range of fields and can refer to multiple areas. If you want to specify several references as a single argument, you must include extra sets of parentheses to avoid interpreting the comma as a field separator.

Example

Formula Description Result 
AREAS([COLUMN1]:[COLUMN2]:[COLUMN3])
 Number of areas in the range 1 
AREAS(([COLUMN1]:[COLUMN2]:[COLUMN3],[COLUMN5],[COLUMN7]:[COLUMN8]:[COLUMN9]))
 Number of areas in the range 3 
AREAS([COLUMN2]:[COLUMN3]:[COLUMN4] [COLUMN2])
 Number of areas in intersection with range 1