I've got 2 Data Extensions. Let's call them A and B
In my Journey, I can only easily include the attributes from the Sendable Data Extension (A) that I'm using to trigger the Journey.
However, I need to include a specific value from the Sendable Data Extension (B) in every unique email that gets triggered by Sendable Data Extension (A).
I've tried using the Lookup function but can't figure how to include a dynamic value to pull into ordinal 4. In the example provided in the documentation, they have a hardcoded value but do not point to how to include a dynamic variable here.
Customer X enters Journey triggered by Sendable Data Extension (A)
Salesforce function needed to look into a specific column in Sendable Data Extension (B) by referencing Customer X's email address (this email address is also available in Data Extension (B) as a cross-reference )
Value gets populated in the email, email gets sent to Customer Y
This is what I have so far, but it isn't working:
CustomerAttributes = Name of data extension from which to return the specified value
referral_link = Name of column from which to return a value
email_address = Name of column used to identify row containing lookup value
referrer_email = Value to match string against