Collection_Cell_First_Non_Null

Scans rightward in a collection's row from a starting cell and returns the name of the column containing the first non_null value and the value in that column as a bracketed list.

Arguments

Collection_Cell_First_Non_Null(
<coll>	// Name of the collection.
, <start-row>	// Expression evaluating to a number, or 'last'.
, <start-col>	// Expression evaluating to the name of a column.
)

Example

In this example, the rules engine goes to the column CAT in the collection mvAA and its value is null. It finds the first non-null value in column LI_NUM, the value 3. Return: [LI_NUM][3]

Collection_Cell_First_Non_Null(

'mvAA', 'last', 'CAT' )