Field mapping string field to reference field

[Sathiskumar_D]

Hello,

I have JSON data in the Staging table field.

I have to map with reference field in table.

But transformation is not working as anticipated. Could someone help me ? 

I've also referred other community questions. 

https://community.servicenow.com/community?id=community_question&sys_id=b8f93179db0c67c01cd8a345ca9619eb

https://community.servicenow.com/community?id=community_question&sys_id=83ed1ac4db2c90104819fb2439961950

[Sathiskumar_D]