Importing data for choice list

[Anubhav24]

Hi All,

I am trying to import data into one of my choice list using transform map into sys_choice table for a particular field,

I want to know how should i use the transform map to get the data , I have done all the mapping of the fields, but my query is to know what will happen for the choice list when the data gets imported through transform map how will it map to the field having multiple values to it and also if I get a duplicate then how do I handle it.

Thanks in advance.

[Richard P]

It should map coalescing perfectly if the text in the import matches exactly like that of the choice list values. subtle data differences like " " spaces may create a duplicate record though. 

but since its a choice list there usually wouldn't be *many options that would need validating or concern?

[Anubhav24]

Hi Richard,

Do I need to implement any script , I am confused can you please explain your answer in detail.

Thanks.

[Priya Shid1]

Hi Anubhav,

If you want to import data for choice list you can directly import it using mapping it will work and set the value for particular choice field.

If you don't want duplicate then make coalesce= true for that field.

Please Mark if Found Helpful.