Import a spreadsheet to update a list field on a CI. If exists do nothing, if not then add to list.

[JM316]

The spreadsheet has 2 columns: 

The Name of the CI record that needs updated and the Code which is a list field type on the CI record.

Source

Column A:Name of CI       Column B:Code is in the List field on the target CI

Phone                                             New York

Phone                                            Chicago
Desk                                               Maine

Desk                                               Las Vegas

When this spreadsheet is imported I need to lookup the CI in column A and if the Target.Code field contains B in the Code list field then do nothing. This means the Code for that CI Phone already exists in the list field Code.

But if the Code in column B is not contained in Target.Code field then append B to the Target.Code list field. 

[JM316 · Accepted solution]

In my transform map, I think I need to coalesce on the Name of the CI, then my field mapping for source.code to target.code I have to see of source.code is already contained in the target.code list field and if not it will append source.code to the target.code list field using source code script.

[VernYerem]

Column B:Code, you say this is a list field. The list field type can be handled two ways, manually added choices or a table reference. Do you happen to be using a table reference?