Transform map - more than one target records exists

[Colleen]

I've created a transform map with 3 coalesce fields.  The student field on the target table is a reference field.  The source field value may not have a matching record in the student table. The field map choice action is set to reject if the source field value is invalid.  See image below.

Apparently, this warning message is being generated for each record where the source student_id is invalid.

More than one target records exists for target table <table name> with query ...

The problem is that there can be a lot of those warning messages, so I was looking for a way to prevent them being generated.

I tried setting ignore = true in an onBefore script if the source student_id is invalid.  There is a comment on the source record that the row transform was ignored by the onBefore script but the warning message is still being generated. According to this article, coalesce fields are processed before onBefore scripts are executed, so that is apparently expected behaviour.

Is there any way I can stop warning messages being generated if the coalesce field is invalid?

[Colleen]

Implementing the entire transform in the onBefore script is probably an option to avoid as well.  It's a shame that there is apparently no option to set the logging level for imports.

[Ankur Bawiskar]

@Colleen 

yes that's correct.

Unfortunately no other way or inform your customer to stay with that messages.

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

[Ankur Bawiskar]

@Colleen 

Hope you are doing good.

Did my reply answer your question?

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

[Colleen]

Hello Ankur

Your response was helpful but not really a solution.

[Ankur Bawiskar]

@Colleen 

I believe I have provided a workaround for your question considering there is an OOTB limitation.

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