Function: Count

Check to see if a string contains a text fragment

Use this function to count the number of records in a table.

Syntax	Description
Count(Items [, Condition])	Returns the number of records in a table.

Arguments

For more information on arguments, see the table below.

Argument	Type	Description
Items	Required	A list or a table.
Condition	Optional	A condition that must evaluate as true for the item to be counted.

Example

Assume JamTypes is a list of different kinds of Jam:

List(“Apricot”, “Blackberry”, "Blueberry", "Cherry", “Raspberry”, “Peach”, “Strawberry”)

Assume process output JamPrefrences returns the following DataTable:

Name (Text)	Country (Text)	Jam Preference (Text)
Adah	Australia	Apricot
Betty	Brazil	Blackberry
Bob	Brazil	Blueberry
Carina	Cyprus	Cherry

Count(JamTypes): 7

Count(JamPreferences): 4