Transform Map

[Vaibhav Sharma1]

Hi All,

I am trying to understand "how to restrict transform map from creating any new record, only update, even if values of coalesce fields not matching".

Any inputs are valuable

[Ankur Bawiskar]

@Vaibhav Sharma1 

you should use onBefore transform script and stop

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

	// Add your code here
	if(action == 'insert'){
		ignore = true;
	}

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

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Dr Atul G- LNG]

Hi @Vaibhav Sharma1 

This is the purpose of colsec. if match update else create new record. What is use case you have to not to create new record.