LookupOrderedRows

Overview

Retrieves the value of a specific field from a column in the specified data extension.

Syntax

LookupOrderedRows(1, 2, 3, 4, 5)

Function Properties

OrdinalTypeDescription
1stringRequiredName of data extension from which you want to return specified rows
2numericRequiredNumber of rows to return. A value less than 1 returns the default 2000 rows. This limitation enhances script performance.
3stringRequiredIndicates how to order returned rows, including the value and ASC or DESC
4stringRequiredField to use to build WHERE clause.
5stringRequiredValue to use to build WHERE clause.

Examples