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

Bart Z · ‎02-07-2022

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?

shloke04 · ‎02-07-2022

I see you have marked an answer as correct, but I believe that is a partially answer as that error will not throw up all the time for every incorrect mapping.

To make it clear, let's say when you are defining a Field Map you need to select a field in the Target column and say for example I have mapped Category to Short Description, it will not thrown any error and it will map it across to Short Description field.

There can be error message which will come up when you are trying to map a field which are not of same Dictionary Type.

Which means in Source Field you are having it as a String and in Target you are trying to map this to a Different field Type say Boolean then it will not work

In short, Along with this for different scenario there can be different error message coming up and not just 1 specific highlighted above.

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

View solution in original post

Saurav11 · ‎02-07-2022

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 · ‎02-07-2022

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 · ‎02-07-2022

Hello

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

There will no invalid insert in system dictionary..

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

Regards

Sulabh Garg

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

shloke04 · ‎02-07-2022

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