Unable to resolve target record, coalesce values not present:

[palvindersingh]

Hello All,

I need to load data from .CSV file to database using Transform Map viva email attachment.

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

I have tested using single entry in the .csv file that contain coalesce value that is name. still it throws the same error.

Kindly assist.

Took Help from below link too:

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

Thank you in advance..!! 

Palvinder

[Slava Savitsky]

You might find this article helpful:

Transform error: Unable to resolve target record, coalesce values not present

[Harsh Vardhan]

seems like the u_name in staging table is empty ? can you please confirm. 

i am adding one article link here, which has explained the resolution for the error which is coming in your case. 

https://hi.service-now.com/kb_view.do?sysparm_article=KB0547762

[Brett Watson]

Kia ora all,

Came across this post when we had a similar error and for us it turned out that the file format was not correct.

For our import the file encoding needed to be ANSI and we were using UTD-8. Once we changed to ANSI the import worked.

Cheers,

Brett