This is going to be a fairly easy question for you I think.
I have a lookup aimed at a Data Extension, but I want to set a default value for all lookups that does not find a value in the DE.
Here is the complete script I have right now for reference - SnipSave.
And here is the Data extension - Google Documents
It contains more variables but lets just focus on one now. So here is a rough "mockup" what I want to achieve
IF @studyloc = *values from first coloumn in DE* SET @studyloccorr = Lookup("SFdataCorr_StudyWhere", @prefix_lang, "StudyWhere", @studyloc) ELSE SET @studyloccorr = *default value*
The default value should be different depending on the country as well (column headers) just like all the other values (like NewYork for example).
So if the
@prefix_lang = EN then the default value should be "default", but if
@prefix_lang = ES then the default value should be "vamos" (stupid example)... and so on with every column.
So essentially we would insert an additional row for the default values in theory, but I'm not sure then how would we say if the lookup was unsuccessful then look at this added row.
Can you help me with this or steer me to the right direction?