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:

In an extract transformation the LAST value applies to the previous record retrieved from the data source before sorting takes place.
In a load transformation, the LAST value applies to the record in the previous record loaded.

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.

LAST retrieves the previous value of DEPARTMENT:

LAST DEPARTMENT

	WebFOCUS