Issue with coalesce a reference field

[Abilash Vangara]

Hello,

I am facing an issue with the transform map while loading data. The source field(contains a string name) is mapped to the target field(reference) and coalesce is set on this field map. Though an exact match is found the records are inserted instead of updating.

The coalesce is set to 3 fields, the other 2 field coalesce works fine when I tried coalescing only 2 of them...

Also tried putting the reference field name on the field map though the name field is the display value of that table...

Any thoughts would be greatly appreciated...

Thanks in Advance,

Abilash

[Harish Murikina]

In order to restrict inserting the option the below script can restrict your issue.

if (action == "insert")

  ignore = true;

[Abilash Vangara]

Thanks for the reply harish,

I also want the records to insert when the coalesce doesn't match.....

Any alternative way of writing an onBefore script which does the coalesce functionality?

[Michael Fry1]

I think you will have to write the onBefore script that query's the existing table for a match before inserting.

[Abilash Vangara]

Absolutely Michael, I can still write an onBefore script to check for a match and ignore the insertion but I want that to be updated when there is a match ....

Is there any way like "action = update" kind to update the record when a match is found?