{"id":31468,"date":"2018-04-21T15:47:47","date_gmt":"2018-04-21T15:47:47","guid":{"rendered":"https:\/\/ampscript.guide\/lookuprowscs\/"},"modified":"2021-04-06T01:18:30","modified_gmt":"2021-04-06T01:18:30","slug":"lookuprowscs","status":"publish","type":"post","link":"https:\/\/ampscript.guide\/lookuprowscs\/","title":{"rendered":"LookupRowsCS"},"content":{"rendered":"

LookupRowsCS<\/h2>\n

This function returns a set of unordered rows from a Data Extension. This variation of the LookupRows<\/a> function treats selection values as case-sensitive.<\/p>\n

Arguments<\/h3>\n

LookupRowsCS(1,2,3,[4a,4b]...)<\/code><\/p>\n\n\n\n\n\n\n\n\n\n
Ordinal<\/th>\nType<\/th>\nRequired<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
1<\/td>\nString<\/td>\nTrue<\/td>\nName of the Data Extension from which to return rows<\/td>\n<\/tr>\n
2<\/td>\nString<\/td>\nTrue<\/td>\nName of the column that identifies the rows to retrieve<\/td>\n<\/tr>\n
3<\/td>\nString<\/td>\nTrue<\/td>\nValue that identifies the rows to retrieve<\/td>\n<\/tr>\n
4a<\/td>\nString<\/td>\nFalse<\/td>\nAdditional column name that identifies the rows to retrieve (see note)<\/td>\n<\/tr>\n
4b<\/td>\nString<\/td>\nFalse<\/td>\nAdditional value that identifies the rows to retrieve (see note)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n

NOTE: Additional pairs of columns and values can be appended as arguments.<\/p>\n<\/blockquote>\n

Example 1<\/h3>\n

Data Extension<\/strong>: LoyaltyMembers<\/em><\/p>\n\n\n\n\n\n\n\n\n\n
Name<\/th>\nData Type<\/th>\nLength<\/th>\nPrimary Key<\/th>\nNullable<\/th>\nDefault Value<\/th>\n<\/tr>\n<\/thead>\n
EmailAddress<\/td>\nEmailAddress<\/td>\n254<\/td>\nN<\/td>\nN<\/td>\n<\/td>\n<\/tr>\n
SubscriberKey<\/td>\nText<\/td>\n254<\/td>\nY<\/td>\nN<\/td>\n<\/td>\n<\/tr>\n
FirstName<\/td>\nText<\/td>\n50<\/td>\nN<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
Region<\/td>\nText<\/td>\n50<\/td>\nN<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
Rank<\/td>\nNumber<\/td>\n<\/td>\nN<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The LoyaltyMembers<\/em> Data Extension includes these rows:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
EmailAddress<\/th>\nSubscriberKey<\/th>\nFirstName<\/th>\nRegion<\/th>\nRank<\/th>\n<\/tr>\n<\/thead>\n
doug@limedash.com<\/td>\n8473<\/td>\nDoug<\/td>\nnorth<\/td>\n1<\/td>\n<\/tr>\n
suzy@limedash.com<\/td>\n5497<\/td>\nSuzy<\/td>\nNorth<\/td>\n3<\/td>\n<\/tr>\n
dale@limedash.com<\/td>\n7114<\/td>\nDale<\/td>\nWest<\/td>\n2<\/td>\n<\/tr>\n
barb@limedash.com<\/td>\n5767<\/td>\nBarb<\/td>\nNorth<\/td>\n1<\/td>\n<\/tr>\n
curt@limedash.com<\/td>\n5152<\/td>\nCurt<\/td>\nnorth<\/td>\n2<\/td>\n<\/tr>\n
nora@limedash.com<\/td>\n7014<\/td>\nNora<\/td>\nSouth<\/td>\n1<\/td>\n<\/tr>\n
leon@limedash.com<\/td>\n8225<\/td>\nLeon<\/td>\nEast<\/td>\n3<\/td>\n<\/tr>\n
lily@limedash.com<\/td>\n9496<\/td>\nLily<\/td>\nEast<\/td>\n1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Here is an example utilizing the preceding context:<\/p>\n

%%[\nvar @rows, @row, @rowCount, @region, @i\n\nset @region = AttributeValue(\"Region\") \/* value from attribute or DE column in send context *\/\nset @region = \"north\" \/* or a literal value *\/\nset @rows = LookupRowsCS(\"LoyaltyMembers\",\"region\", @region)\nset @rowCount = rowcount(@rows)\n\noutput(concat(\"region: \", @region))\n\nif @rowCount > 0 then\n\n  for @i = 1 to @rowCount do\n\n    var @emailAddress, @firstName, @rank\n    set @row = row(@rows, @i) \/* get row based on counter *\/\n    set @firstName = field(@row,\"firstName\")\n    set @emailAddress = field(@row,\"emailAddress\")\n\n    ]%%\n\n    <br>Row %%=v(@i)=%%, firstName: %%=v(@firstName)=%%, emailAddress: %%=v(@emailAddress)=%%\n\n    %%[\n\n  next @i ]%%\n\n%%[ else ]%%\n\nNo rows found\n\n%%[ endif ]%%<\/code><\/pre>\n
Output<\/h4>\n
region: north\nRow 1, firstName: Doug, emailAddress: doug@limedash.com\nRow 2, firstName: Curt, emailAddress: curt@limedash.com<\/code><\/pre>\n
Example 2<\/h3>\n
\n\n\n\t\n\t
\n\n\t\t\n\t\t