I'm having some issues with this AMPscript code and getting it to work properly within Journey Builder.
First, here is the code I am working with (I've switched the field names to general names to have it make sense)
%%[ VAR @value1, @value2
SET @value2 = AttributeValue("sending_de_value")
SET @value1 = Lookup("other_de","other_de_column","other_de_id",@value2)
]%%
%%=v(@value1)=%%
So, the Journey is using Salesforce Data for the entry source and I tested out the script within Email Studio on the Data Extension that MC creates for the Salesforce Data entry event and the code works as planned. However, in the actual email send through Journey Builder it does not pull in the value.
Has anyone experienced this? The values, etc. all match up.
@entityid
being defined.@value2
is outputting a non-null value in JB? The issue could be related to the value in the 'Journey Data' is null or does not match what is inside your DE. More info on Journey Data, Attributes/Personalization Strings and Contact Data: help.salesforce.com/…sending_de_value
a field name in your event source DE used by the Journey and if so, does it contain a value for records injected in the Journey?