map the string value in source field to reference type target field using onbefore transform script

[SK41]

Hi,

I have a requirement where i need to map the source value which is string to the target model id field which is reference  type.

The requirement is that in case of insert only i need to map the source model id field to target model id field which is reference in onbefore transform script but the value is not getting mapped. I  cannot use field map to achieve this as i just need to map only in case of insert not update.

Kindly, assist how can i map the reference field with the string type source field in transform script.

Thanks!

[priyasunku]

Hi @SK41 

we cannot map string value to reference field. you have glide to the referenced table and map the field.

Please mark it as helpful if your issue is solved

[Anwesha3]

Hi @SK41 

Did you find any solution?