Don't set new choice when import data

[palims]

Hi,

I want to import a file to a table. With the import I also import set choices to a existing choice list field. If the choice doens't exist it wll be created. Is there any way to avoid that? I don't want new choices when I import a file just because a letter is missing in the field or something like that. I hope you understand me.

Is there a possible to not update the choice list field if the choice does not exist? Or if not ignore the whole record?

Thanks in advance.

[SatheeshKumar]

you can set the value of choice action to ignore, so that the new choice will not be added to your target table.

 modify the choice action value from Create to Ignore.

• ignore – ignores new records in the choice field and completes processing of all other fields in the transform map.

[asifnoor]

Hi Palims,

While doing a transform map, you have options like these (Create, ignore, reject). if you select create, then if the value does not exist, it will create. So in your case, you need to choose ignore, so that the new value is not created.

Mark the comment as a correct answer and helpful if it answers your question.

[siva_ · Accepted solution]

Hope this definetely helps : 

This field is available if the target field is a choice list or reference field. This field specifies what to do if the import set contains a reference or choice value other than those available. Select one of these options:

• create: Create a new choice or record in the reference table.
• ignore: Ignore the new value from the source table.
• reject: Skip the entire row (record) containing the new value and continue to the next row.

Thanks

Siva

Mark this response as correct if that really helps