Description
Remembers a name/value pair that is saved across source rows. The value can be retrieved at any time using GETNAMEDVALUE. The value is not saved across executions of a process. Returns the value that was passed in.
Syntax
SETNAMEDVALUE ( name, value )
| Parameter | Description |
|---|---|
| name | String that identifies the value. This allows multiple values to be stored at once, each with a different name. Not case-sensitive. |
| value | The value to store. |
Remarks
The value set by SETNAMEDVALUE persists until it is changed by another call to SETNAMEDVALUE. Compare this to a user variable, which is automatically recalculated for every source row. This function is useful for logic that spans multiple source rows.
Examples
The follwoing example sets the "End-of-Day" to the date "31-Nov-2015":
SETNAMEDVALUE( "End-of-Day", "31-Nov-2015" )
See also