LAST: Retrieving the Preceding Value

How to:

The LAST function retrieves the preceding value for a field.

The effect of LAST depends on whether it appears in an extract or load transformation:


Top of page

x
Syntax: How to Retrieve the Preceding Value
LAST fieldname

where:

fieldname

Alphanumeric or Numeric

Is the field name.

Note: LAST does not use an output argument.



Example: Retrieving the Preceding Value

LAST retrieves the previous value of DEPARTMENT:

LAST DEPARTMENT

iWay Software