RECNUM
Syntax
RECNUM ( )
Description
Returns the current value of a running count of records. The records being counted are the result of the outer source query of the flow. Counting starts at 1 and is incremented by one when a record is retrieved.
Returns
Returns 1 while the first record is being processed, 2 while the second record is being processed, and continues to increment with each subsequent record.
Remarks
The counter is reset each time the flow is run.
Example
RECNUM( )
Returns: Returns 1 while the first record is being processed, 2 while the second record is being processed, and continues to increment with each subsequent record.