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?
Thanks!