Lookup default value - AMPscript

Question

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?

Regards, Balint

Answer 1

You may want to use LookUpRows() instead of LookUp(). You can test the number of rows returned with LookUpRows() using rowcount, and default if nothing is returned.

LookUpRow returns a rowset. Row is used to access a row from the RowSet (1 indexed). Field is then used to access a field from the row.

@RS = LookUpRows("DEName", "FieldName1", "ValueToQuery")
@Row = Row(@RS, 1)
@FieldValue = Field (@Row, "FieldName2")

Answer 2

-- OR -- You could do this, which is a little more simple:

SET @studyloccorr = Lookup("SFdataCorr_StudyWhere", @prefix_lang, "StudyWhere", @studyloc)

IF Empty(@studyloccorr) THEN
  SET @studyloccorr = "default value"
ENDIF