Unable to resolve target record, coalesce values not present: u_field_name

[Devika3]

Hello All,

We need to load data from an excel file that we are getting through an email attachment to a target table Transform Map  .

Problem is when Transform Map is running, it is giving an error: Unable to resolve target record, coalesce values not present: u_field_name.

I have tested using single entry in the excel file that contain coalesce value that is field name. At that time it is working. When coming to bulk it is not.

Took Help from below link too:

https://community.servicenow.com/community?id=community_blog&sys_id=908c26e1dbd0dbc01dcaf3231f9619c4

Thanks in advance..!! 

Devika.

[Weird · Accepted solution]

There shouldn't be an issue if the fields match the rows in the excel.

I assume you've tested this by taking the excel received via email and removing all but one row and then used load data to process the excel manually? And then it doesn't manually work if you have all of the rows intact?

If you created the excel yourself then something might be different between them. I'd check the email one and make sure there are no differences with the top rows, the data is in correct sheet and that the excel file isn't using any weird encoding or file type that might not be recognized by SN.