How to set choice field value to --None-- which is default value in target field using transform map if source field value is empty?

[Priya Shid1]

How to set choice field value to --None-- which is default value in target field using transform map if source field value is empty?

[Jaspal Singh]

In your transform map you have 'Copy Empty Fields' which would copy all empty fields & set it to empty for all fields.

If you want it to be specific for some fields then you can use transform script as 

if(source.u_yourfieldname=='')

{

return '';

}

[Priya Shid1]

hi jaspal,

I checked 'Copy Empty Fields' and also used this code ,

if(source.u_yourfieldname=='')

{

return 'None';

}

but it is creating new choice i want to set it to default --None-- how can i set this value for target?

[Priya Shid1 · Accepted solution]

Hi,

Got the answer --None-- is system default which we cannot use if we want to set the value we have to create new choice and then have to use that value to set.