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]

Any leads

[AshishKM]

Hi @Priya123 

Did you check the value of "source.isDelayed" in the import set table. 

The value in file and import set table ( before transform ) both are same?

-Thanks

[Priya123]

yes they are same ....  

am just wondering how they would update in the second iteration

[Priya123]

thats a True/False field type if this information would help