Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Field Mapping

NARASIMHA REDD5
Tera Contributor

Hi Team,
Good Morning.

"I am facing an issue with mapping the field from source to target. We have a 'monitor' field on the CMDB form. I attempted to map the value, but instead of 'true' or 'false', I am receiving '0' or '1'. How can I resolve this issue?"

 

NARASIMHAREDD5_0-1708756479669.pngNARASIMHAREDD5_1-1708756546000.png

 

22 REPLIES 22

Thanks for quick Response.

It is Target Field. field type is true/false

NARASIMHAREDD5_0-1708938338629.png

Below one is Source table field.

NARASIMHAREDD5_1-1708938506080.png

 

 

can you also show what is loaded in your import set table  ? lets see what values do you get after loading the data.


☑️ Please mark responses as HELPFUL or ACCEPT SOLUTION to assist future users in finding the right solution....

LinkedIn - Lets Connect

The below Excel Data I was imported.

Soucrce Table

NARASIMHAREDD5_0-1708939152002.png

Target Table 

NARASIMHAREDD5_1-1708939231379.png

 

 

@NARASIMHA REDD5 ,

 

Thanks for sharing the detailed info, the issue is in your Excel sheet, the true and false are treated as 0 and 1 in your excel sheet, that the reason your import set consider it as 0 and1.

 

try the value 'true' in small letters make sure your column 'is Monitored' does not have any special filters applied to it. 


☑️ Please mark responses as HELPFUL or ACCEPT SOLUTION to assist future users in finding the right solution....

LinkedIn - Lets Connect

I Tried now. But still aim getting Same. Could you please find below Screen shots.

NARASIMHAREDD5_0-1708940598993.pngNARASIMHAREDD5_1-1708940637412.png