I'm looking for a solution for the following topic (not sure if it's even possible but I try): We have two separate DEs, one is storing the email address (the one I sent to) and the other one the values I use in my AMP Script via lookup function.
AMP script looks like this:
%%[ var @Location, @Language, @replyName, @subscriberkey Set @subscriberkey = PVSID Set @Location = Lookup('Test_Greta_AMP_no_email_Copy','Country','PVSID', @subscriberkey) Set @Language = Lookup('Test_Greta_AMP_no_email_Copy','Language','PVSID', @subscriberkey) if @Location == "Ukraine" and @Language == "Ukrainian" then set @replyName = "Anna" elseif @Location == "Ukraine" and @Language == "English" then set @replyName = "Greta" else set @replyName = "SORRY" endif ]%%
(test version at the moment)
The Problem now is that PVSID, which I set as subscriber key, is the unique identifiier and available in both the Data Extensions, however, due to the company structure, the column name of this identifier is named different in the DEs - in one its "PVSID" in the other one "BPID", the values are the same.
Is there any solution for that, like setting two different names for the subscriber key or sth??