We have couponcode email flow where we want to send out a reminder email to those who didn't use the code. We have several data extension with codes, because we have had to use new codes on a regular basis. The issue is that the list of customers we want to sent to has codes from different data extensions. So my question is - is it possible to do a LookUp in 2 different data extensions, somewhat like this:
%%[ VAR @CouponCode SET @CouponCode = Lookup("FLIPP-DK2016_new", "CouponCode", "Contact_Key", _SubscriberKey) SET @CouponCode = Lookup("FLIPP-DK2017", "CouponCode", "Contact_Key", _SubscriberKey) ]%%
I am aware that this is not the way to do it, because it is not working for me. Any suggestion to how to solve it?