I can rephrase the problem statement and the resolution for you.
- Problem statement: You are receiving data in a staging table, but you are seeing an error when you try to transform it. The error message is "Unable to resolve target record, coalesce values not present."
- Resolution: This error can occur for two reasons:
- Synchronous transform: In the case of a customized Web Service/REST import, the most likely cause is that the record is inserted into the source table, but the coalesce value is not yet populated. This happens when the coalesce value is updated in the import set table after the insert. The synchronous transform triggers on an insert into the source table, and since the coalesce field is empty, throws the error.
- Asynchronous transform: In this case, the coalesce is most likely on a script that is returning a NULL value.
To resolve this error, you can try the following:
- Synchronous transform: Wait for the coalesce value to be populated in the import set table before triggering the synchronous transform.
- Asynchronous transform: Check the script that is returning the NULL value and make sure it is returning a valid value.
If you are still having trouble resolving this error, please contact customer support for assistance.
I hope this helps! Let me know if you have any other questions.
