Transform Script - Updating values on second run

[Priya123]

hi 

have a transform script that updates a value on a True/False field on customer project table. 

so import set has a column has is delayed (Y/N) and based on that the Has Issue value on customer project table is updated.

so it goes like :

var flag;

if (source.isDelayed =='Y')

flag = true; (or flag='true';)

else 

flag = false ;

return flag;

have played with quotes, placing the script inside loop etc. everytime  i rerun the import, for change of the is delayed column, the table value is not updated 1st time but same File i Load , import and transform second time, the values are updated correct.. 

any one faced such an issue before?? 

[Priya123]

i have attached already

[Priya123]

Have attached the xml of the transform and the data source

[Tony Chatfield1]

Hi, unfortunately neither of these files show the script you identified in your first post.

If the script is a 'field map' script, then the record type is sys_transform_entry

If the script is a beforeTransform script, then it will be a sys_transform_script record.

[Priya123]

String from Excel To String ( as defined in SN but has choices)

String from Excel to True/False field in SN...

are these not possible then ?

on before as well would not work cos of data type...