COUNT function

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

Description

Counts how many numbers are in the list of arguments. The following would count the number of numbers in the first four columns of data:
COUNT([Column1]:[Column4])

Syntax

COUNT(value1,value2, ...)

The COUNT function syntax has the following arguments:

  • value1 Required. Reference to a field or range of fields.
  • value2, ... Optional. Additional references to fields or ranges of fields.

Example

Table 1. Data record
Id First_Name Last_Name House_Number Street City Postal_Code
27 Samuel Lemon 433 Chester Road London W64 5HY
Table 2. Count of non-empty values
Formula Description Result
COUNT([Id]:[Postal_Code]) Numbers in range of all seven fields in record. 2
COUNT([Id],[First_Name],[Last_Name]) Numbers in three separate fields in record. 1