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