DGET function

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

Description

Extracts from a database a single record that matches the specified criteria.

Syntax

DGET(database, field, criteria)

The DGET function has the following arguments:

  • database Required.
  • field Required.
  • criteria Required. Field that contains the conditions.

Notes

  • If no record matches the criteria, DGET returns the #VALUE! error value.
  • If more than one record matches the criteria, DGET returns the #NUM! error value.

Example