UPSERT_ROW

Updates a row or inserts a new row (after last row in Target Frame).

Syntax

UPSERT_ROW(targetFrame, searchExpr, frameOrRangeToUpsert)

• targetFrame - Target Frame.

• searchExpr - Search Expression.

• frameOrRangeToUpsert - Frame/range to upsert.

Sample Usage

UPSERT_ROW(C1, "@number = 2", C2)
UPSERT_ROW(C1, D1, A6:B6)

Return Value

• TRUE if function modified the targetFrame.

• FALSE otherwise.

Notes

In order for UPSERT_ROW to work, the first argument targetFrame must be a FRAME.

See Also