Hi @Max Nowak,
Interesting, I have done some testing on my PDI as well with the configurations very similar to yours:
- Data source with 2 columns (number and short description) with the target to the Incident table
- Field Map (number and short description where number's coalesce is set to true)
- onAfter Transform Map with the same script as yours
- A BR on the Incident table (insert & update) with the same condition and script as yours
So..... if you have a coalesce field map, the BR is executed only once.
But if you don't have a coalesce (i.e. I removed the number field map from the Transform Map), the BR is executed twice.
The top 2 logs of the screenshot below represent the transformation where there is no coalesce and the last log represents where a coalesce was set.
What's interesting is, even if you don't update any fields within onAfter Transform Script and just have target.update(), the BR is executed twice.
Not entirely sure what's going on, but is it possible for you to set up a coalesce field map?
That (hopefully) should fix the issue.
Cheers
