I have a transform map where i only want to issue an update to records where there is a coalesce mapping on the ID field.
There is an onBefore script where i specify ignore = true if the action is insert
If the 3rd party calls the SN webservice and inserts records into the import table, then the action on the transform map is insert and the row is ignored. Even though there is a record in the target table.
However, If I reprocess the import set and transform the data, then all works as expected??
The coalesce is on the ID field in the transform map,
Import Row
The record i am trying to match:
I output the values in the onBefore Script:
When manually re-process the import set, I get the proper result (notice the comments still show the initial ignore):
Coalesce on the transform map
