I need to populate an HREF by looking up a value in a data extension. Here's what I'm using as the email AMPscript to generate the HREF URL:
%%[ Var @LINK_VALUE, @EMAIL_ADDRESS, @BASE, @LINK_VALUE_1 Set @EMAIL_ADDRESS = EMAIL_ADDRESS Set @BASE = 'http://' Set @LINK_VALUE = Lookup('TABLE_1','LINK_URL','EMAIL_ADDRESS',@EMAIL_ADDRESS) Set @LINK_VALUE_1 = concat(@BASE, @LINK_VALUE) ]%%
This script returns
http:// and nothing else. I've verified the records I'm previewing against do have a value in
TABLE_1 so am unsure of why this is happening.