when record is importing i want to set error message for refernce field those have no matching value

[Jyoti Ranjan Se]

i want to write a transform map script to show an error message when mapped a reference field value not in target table reference field.How to write can you please help me on this.

Thanks 

Jyoti

[Ankur Bawiskar]

@Jyoti Ranjan Se 

you should use onBefore transform script for this

1) get the source value, query target field's reference table and search if record is present or not

2) if not then use this to add error message

log.info("This is an information message"); 
log.warn("This is a warning message");
log.error("This is an error message");

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Jyoti Ranjan Se]

can you please provide the complete script and process

[Dr Atul G- LNG · Accepted solution]

Hi @Jyoti Ranjan Se 

Please try to google it the baseline code and give a try.