Transform Map Query for 'Ignore' Choice Action

[_Yash24]

Hi All,

I'm running transform map, In field map even if we keep choice action as 'Ignore' , choices are getting created in ServiceNow instance also what is the purpose of the Reference value field name on the field map window of the transform map?

Please help me to understand.

[AnveshKumar M]

Hi @_Yash24 ,

Regarding inserts even the choice action is set to ignore, What is the type of the target field [Select free items 2- (Classification)]? Is it Choice field or Reference field? As you are specifying Referenced Field Value Name, I think it is reference field? Confirm this.

And, Choice Action works only works on Choice or Reference type target fields.

Referenced Field Value Name is an optional field, if it is specified it searches that particular field in the referenced table to find a match, if it is not specified it matches the default "Display" field. As per the documentation, 

For example, suppose you are importing incident records and the incoming data lists user IDs for the Assigned to field. If you leave Referenced value field name blank, the transform map searches for matching values in the User table's display value column: name. By setting the Referenced value field name to the user_name column, you can match the user ID values to the appropriate user records.

You can check this link for more info, https://docs.servicenow.com/bundle/tokyo-platform-administration/page/script/server-scripting/task/t... 

Thanks,

Anvesh

[_Yash24]

Hi @AnveshKumar M ,

Thank you for your reply.

Yes, It is reference field.
I would like to know why records are getting created in Target table even if choice action is ignore.

Thanks

[AnveshKumar M]

@_Yash24 ,

You mean to say Choices are getting created or the Record is getting created?

If the record is getting created, that is expected only the field will be left blank. If you don't want this change the choice action to Reject.

If the choice is getting created, you have to debug by analyzing some thing like node logs.

Note: I hope you are not using any source script?

Thanks,

Anvesh

[_Yash24]

Hi @AnveshKumar M ,

Thank you again for reply.

Record is getting created, I have one more question, If source data contains existing record in ServiceNow instance then what would be the field value, Does it take existing value or empty value, if choice option is set as ignore.

For example: If source contains existing value of "record1" then would be field value?

Thanks.