Data Mapping script error

Jul 13, 2016 11:29AM

Hi All,

Can you please correct the script? I am getting error message "

ERROR [AIF]: The script based mapping 'ZICPAll' (LIKE) has failed to compile:

mismatched input 'case' expecting NEWLINE (<string>, line 1)

2016-07-13 09:10:04,255 INFO [AIF]:

Processing Mappings for Column 'UD1'"

select case fdmRow.getString("ACCOUNTX")

case "1103000", "1210000", "1220000", "1222000", "1510000", "1520000","1701000"

tempvar = fdmRow.getString("ICP")

if tempvar = "1601":

fdmResult = "1601_GlobalExp"

elif tempvar = "#":

if fdmRow.getString("ENTITYX") = "1601_Corp":

fdmResult = "1601_Other"

else:

fdmResult = "1601_Corp"

elif tempvar = "1601_Corp":

if fdmRow.getString("ENTITYX") = "1601_Corp":

fdmResult = "1601_Other"

else:

fdmResult = tempvar

else:

fdmResult = tempvar

case else:

fdmResult = "[ICP None]"

Thanks

Nani

Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC)