LookupRows

by | Apr 21, 2018 | Book |

LookupRows

This function returns a set of unordered rows from a Data Extension.

Arguments

LookupRows(1,2,3,[4a,4b]...)

Ordinal Type Required Description
1 String True Name of the Data Extension from which to return rows
2 String True Name of the column that identifies the rows to retrieve
3 String True Value that identifies the rows to retrieve
4a String False Additional column name that identifies the rows to retrieve (see note)
4b String False Additional value that identifies the rows to retrieve (see note)

NOTE: Additional pairs of columns and values can be appended as arguments.

Example 1

The following illustrates the use of this function with the minimum number of arguments.

Data Extension: LoyaltyMembers

Name Data Type Length Primary Key Nullable Default Value
EmailAddress EmailAddress 254 N N
SubscriberKey Text 254 Y N
FirstName Text 50 N Y
Region Text 50 N Y
Rank Number N Y

The LoyaltyMembers Data Extension includes these rows:

EmailAddress SubscriberKey FirstName Region Rank
doug@limedash.com 8473 Doug north 1
suzy@limedash.com 5497 Suzy North 3
dale@limedash.com 7114 Dale West 2
barb@limedash.com 5767 Barb North 1
curt@limedash.com 5152 Curt north 2
nora@limedash.com 7014 Nora South 1
leon@limedash.com 8225 Leon East 3
lily@limedash.com 9496 Lily East 1

Here is an example utilizing the preceding context:

%%[
var @rows, @row, @rowCount, @region, @i

set @region = AttributeValue("Region") /* value from attribute or DE column in send context */
set @region = "North" /* or a literal value */
set @rows = LookupRows("LoyaltyMembers","region", @region)
set @rowCount = rowcount(@rows)

output(concat("region: ", @region))

if @rowCount > 0 then

  for @i = 1 to @rowCount do

    var @emailAddress, @firstName, @rank
    set @row = row(@rows, @i) /* get row based on counter */
    set @firstName = field(@row,"firstName")
    set @emailAddress = field(@row,"emailAddress")

    ]%%

    <br>Row %%=v(@i)=%%, firstName: %%=v(@firstName)=%%, emailAddress: %%=v(@emailAddress)=%%

    %%[

  next @i ]%%

%%[ else ]%%

No rows found

%%[ endif ]%%

Output

region: North
Row 1, firstName: Doug, emailAddress: doug@limedash.com
Row 2, firstName: Suzy, emailAddress: suzy@limedash.com
Row 3, firstName: Barb, emailAddress: barb@limedash.com
Row 4, firstName: Curt, emailAddress: curt@limedash.com

Example 2


Not a subscriber? Subscribe now.

Example 3


Not a subscriber? Subscribe now.