New SF data correction AMPscript - StudyWhere only
%%[
var @rows, @row, @rowCount, @splitname, @prefix_lang
var @lookupValue
set @studyloc = [Study Where]
SET @splitname = BUILDROWSETFROMSTRING([emailname_],"-")
IF ROWCOUNT(@splitname) > 1 THEN
SET @prefix_lang = FIELD(ROW(@splitname,1),"VALUE")
ENDIF
set @rows = LookupRows("SFdataCorr_StudyWhere","StudyWhere", @studyloc)
set @rowCount = rowcount(@rows)
if @rowCount > 0 then
var @studyloccorr
set @row = row(@rows,1) /* get row #1 */
set @studyloccorr = field(@row,@prefix_lang)
else
SET @studyloccorr = Lookup("SFdataCorr_StudyWhere", @prefix_lang, "StudyWhere", "default")
endif
]%%