AMPScript Lookup Examples

Here are a few ways to retrieve external data with AMPScript inside your email or landing page:

Lookup value of single column value from a certain row

Lookup multiple column values from a single row

Lookup multiple column values from multiple ordered rows

For further reference:



Leave a Reply

8 Comments on "AMPScript Lookup Examples"

Notify of
avatar
Sort by:   newest | oldest | most voted
Vic
Guest

Hey Adam, I want to pull content from a data file (containing one row) that doesn’t have any common columns with the subscribers list. I cannot tie the 2 files together so I cannot use LookUp or LookUpRows. Is there a way to do still do it? Question posted here as well: http://salesforce.stackexchange.com/questions/139997/ampscript-pull-content-from-a-data-file-without-lookup

Javier
Guest

Hello, I cant access the data extension data with a lookup function if it is a shared data extenion

Sebastien
Guest

Hey Adam,
I’ve been trying to retrieve a row filtering on a datetime field.
I’ve tried so many different datetime formats and am still not getting any results.
To be precise what I am trying to do is update a row in SSJS but it is the same issue in AMPScript.
Have you ever managed to retrieve/update a row using a datetime value?
Thanks for your help!
Sebastien

wpDiscuz