Can you please remove the quotes from below true keyword, hoping this is onStart() script?


ignore = 'true';


This is my onstart script



(function transformRow(source,map, log, target) {



  if(action == 'insert'){


ignore = true;


  }


  if(source.ST.validation_ID, == ''){


  ignore = true;


  error = true;


  error_message='Supplier Validation Results field is blank, Please update the field to   complete the update';


  }



})(source, map, log,   target);



this wil only the row skip if validation id is empty, it is not aborting the whole insert if any one validation id is empty.


is the source field name is ST.validation_ID. Can we replace the dot after ST with underscore like ST_validation_ID and also in you if condition there is a comma after ST.validation_ID. Can you please remove that and try. Can we something like this with nil() function.



(function transformRow(source,map, log, target) {


  if(action == 'insert'){


        ignore = true;


  }


  if(source.ST_validation_ID.nil()){


            ignore = true;


          error = true;


          var error_message='Supplier Validation Results field is blank, Please update the field to   complete the update';


          log.info(error_message);


  }


})(source, map, log,   target);


Lösung in ursprünglichem Beitrag anzeigen

Replace the dot after ST with underscore like ST_validation_ID and replace the code like this -> source.ST_validation_ID.nil(),


it is onstart script, still it is not working


Can we change the field name in lower case and try, like: st_validation_id