how to validate empty data in transform map?

jobin1 · ‎03-11-2022

Hi All,

I need to validate below excel data while doing transform load (before loading to table)

Validation should be like if the bae64 data is empty then it should not allow to load data.

Ankur Bawiskar · ‎03-11-2022

@jobin

you can use onbefore transform script

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

	// Add your code here
	if(source.u_base64_data.nil())
		ignore = true;

})(source, map, log, target);

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Ankur Bawiskar · ‎03-13-2022

So what is not working?

if you are using onBefore then it should set the staging table field with the error message

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

jobin1 · ‎03-13-2022

@Ankur Bawiskar So the code which I posted is corrected you're telling?

Regards,

Jobin

Ankur Bawiskar · ‎03-14-2022

Hi,

your code is already correct.

is it not working?

are you using correct field name for import set?

regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

jobin1 · ‎03-14-2022

Yes its correct. I have passed empty bae64 data in excel but it created new record and "error reason" also not updated. Please find the screenshots.

Ankur Bawiskar · ‎03-14-2022

Hi,

inside each if statement you should be adding ignore=true;

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader