IS_FIRST_IN_ITERATION

Description

Returns TRUE the first time a given combination of evaluated expression values occurs in the current iteration, and FALSE for any duplicates after.

Syntax

IS_FIRST_IN_ITERATION(...expressions) -> Boolean

Parameters

ParameterData TypeRequiredDescription
… expressionsObjectYesOne or more expressions combined to determine if this is the first occurrence in the source data iteration.

Example

IS_FIRST_IN_ITERATION(FirstName, LastName)
-- Returns TRUE for the first combination and FALSE for subsequent duplicates.