Transform map - what happens if target field is not existing?

Bart Z
Tera Contributor

Hi 🙂 Is anyone sure what happens if transform map fields are not matching, because target field is simply not existing in dictionary?

import set table field: u_XXX

target field: u_XXX (not present in dictionary)

 

is it just ignored? Or maybe it is somehow created or inserted with unknown data type or anything?

Saurav11
Kilo Patron

Hello,

If the field is not present on the form then it will do nothing. But my question is if there is  nor field present then why and where are you mapping it.

Thanks.

Bart Z
Tera Contributor

It's made after copying the whole transform map and changing the target table. Mapping is a bit too complicated to figure it out on my own, so I am trying to just use all existing ones, and make those that are not matched ignored 🙂 thanks!

Sulabh Garg
ServiceNow Employee

Hello

It will throw error like shown below, where Target field ('category11') does not exist.

There will no invalid insert in system dictionary..

find_real_file.png

Please Mark Correct/helpful, if applicable, Thanks!! 

Regards

Sulabh Garg

Please Mark Correct/helpful, if applicable, Thanks!!
Regards
Sulabh Garg

shloke04
Kilo Patron

Hi,

If the target field is not present then why are you trying to enforce that?

You should not create a Map for that field at all. In case if you need to do validation based on that Source field, you can make use of Transform Script functionality in Transform map and do your calculations.

Refer to below doc:

https://docs.servicenow.com/bundle/rome-platform-administration/page/script/server-scripting/reference/r_MapWithTransformationEventScripts.html

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke