if source field data doesnt map matched with target referene table data then record will be rejected

[Jyoti Ranjan Se]

if source field data doesnt map matched with target referene table data then record will be rejected  and show some error message 

can you please help me on this.

Thanks

Jyoti

[Dr Atul G- LNG]

Hi @Jyoti Ranjan Se 

The data movement from Import set to target table is the last step, before that either you can map manually or via Matching Assit the fields for Source Table and Target table.

Please share more details, if you have further point.

[Jyoti Ranjan Se]

If source field data not found with mapped target reference field then  that record will not insert and give some error message. so i have 5 refernce field to map and check whether this record is exist in target table or not. 

please help me on this 

thanks

Jyoti

[Dr Atul G- LNG]

Hi @Jyoti Ranjan Se 

If source field data not found with mapped target reference field then  that record will not insert and give some error message.

Atul: I assume you already Build the transform map and mapping has been done for Source Field to Target Field.

Now if you insert any field which is type reference if that value doesn't exits

https://www.servicenow.com/community/developer-forum/fail-transform-map-if-the-reference-field-data-...

Instead of create you can choose reject or Ignore. 

[Jyoti Ranjan Se]

yes, correct. But i want to write a transform map script for all these reference field . so can you please help me on this to write that script for validation source data are present or not in target table . after that it will give error message .if data is not inserted/updated.