In transform map target table, alm_entitlement not showing all column filed to map.

[balaji_prusty1]

Hi Team;

I need to transfer/update software entitlement to the table "alm_entitlement " .I cerated transform map to import. While mapping through mapping assist. It is not reflecting all the fields to "alm_entitlement" in the target. Fields like domain, software Model, tags, etc not reflected for mapping. Is this any bug or known things? How to activate these for mapping.

Thanks in Advance.

Balaji 

[Gunjan Kiratkar · Accepted solution]

Hi @balaji_prusty ,

Sometimes it will not map all the fields automatically because of field name from the excel file is not matching with the target table fields.

If it is not mapping then you can click on the new button from the field map-related list. and manually map the fields.

Please mark my answer as helpful/correct if it resolves your query.

Regards,

Gunjan Kiratkar

Consultant - ServiceNow, Cloudaction

Rising Star 2022

[balaji_prusty1]

Thanks It works.

[shloke04]

Hi @balaji_prusty 

Couple of things to note here:

1) This happens and there can be situation where Field Maps are not created automatically.

2) There are two options through which you can create Field Maps as shown below:

a) Using "Mapping Assist Utility":

The mapping assist utility provides a visually intuitive environment for specifying mapping between import set fields and production table fields. The mapping assist utility makes it possible to map a single source field (field on an import set table) to multiple destination fields (fields on a production table).

Click on Mapping Assist as shown in Red below:

Now Select both your Source and Target fields which you want as shown below:

Second method:

In the Transform map scroll down to Related List named as "Field Map" as shown below:

Click on New button as shown in Red above.

Now after click on New button, select your Source and Target fields as shown in Red below:

For more details refer the ServiceNow doc link below:

https://docs.servicenow.com/bundle/sandiego-platform-administration/page/script/server-scripting/concept/c_MappingOptions.html

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

Regards,
Shloke

[balaji_prusty1]

Thanks for the response.