So, I have a Data Extension and every time a visitor on our website visits a product several times, that product ID is sent to a Data Extension.
My Data Extension has these fields:
SubscriberKey, EmailAddress, SHA256, Country Code, ListImageType, ID
By using Lookup I'm able to find out if each visitor has shown interest in a certain product and show them that product or related products.
But if a visitor have shown interest in several products over time, I only want to show them the latest product.. or products related to that product.
I want use Lookup to return a product ID by searching for a visitor ID. But if the visitor appears more than once in my Data Extension, I only want to return the latest entry. How can I accomplish this - can I perhaps alter my code to search from 'the bottom of' my Data Extension?
VAR @ID SET @ID = Lookup('ProductInterestTriggerDE','ID','SHA256',v(SHA256))