Field Mapping

[NARASIMHA REDD5]

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?"

[James Chun]

Hi @NARASIMHA REDD5,

How are you importing the data? IntegrationHub ETL? Data import?

What is the value of the 'monitor' field on the source record?

Thanks

[NARASIMHA REDD5]

Hi @James

Thanks for your replay. I was importing through the import sets.

Source field value are in the Excel sheet given true/false.

[James Chun]

I think you can resolve the issue with one of the two options

• Modify the source field (import set field) type to 'True/False'. You will probably have to delete the existing source field and create one with the same name with the type set to 'True/False'. Or
• Create a Field Map with a script that transforms data from string to boolean. e.g.

answer = (function transformEntry(source) {
    if (source.getValue('monitor') == 'true') {
        return true;

    } else if (source.getValue('monitor') == 'false') {
        return false;

    } else
        return '';


})(source);​

Hope it helps, thanks

[NARASIMHA REDD5]

Hi @James Chun 

Thanks for your Help. 
I am still facing Same Issue. getting 0/1 Value