LookupRows
Returns a rowset from a data extension where the field matches the specified value. Specify additional field value pairs as part of an AND clause. This function returns a maximum of 2000 rows. To better control the number or the order of returned rows, use the LookupOrderedRows() function. This limitation enhances script performance.
Syntax
LookupRows(1, 2, 3)
Function Properties
| Ordinal | Type | Description | |
|---|---|---|---|
| 1 | string | Required | Name of data extension from which to return specified rows |
| 2 | string | Required | Column name used to identify rows to return |
| 3 | string | Required | Value used to match rows to return |
Usage
Returns the ZipCode rows where the City field matches for HomeCity value.