Choice values shows as duplicates on group by

[somujit]

Hello Experts,

I have done a data import of CMDB CI records for Server Class CI's and it child classes like Windows, Linux, ESX, F5BigIP etc using excel spreadsheet.

The data import was successful without any errors and all records got inserted. However, upon doing a Group By using the Status field, I could see duplicate entries on the choice values, not sure why it is being displayed like below and not against a single choice list value.

While doing the data import I have used the correct choice label values for the Status field as available in the system. Any help with letting me know what caused it and the fix would be a great help.

Thanks,

Somujit

[Kumar Ashish]

Hello Somujit,

Please make coalesce as true for a field in the transform map. coalesce will prevent to create duplicate records.

If the reply was informational, please like, mark as helpful or mark as correct!

Reagrds

Ashish

[VenniMakarainen]

I do not see the first response to be accurate. Whenever CMDB imports are executed, IRE is the key to identify correct CIs to update. Traditional transform maps do not include IRE by default but can be incorporated.

Anyways, the question was about the duplicate choices. I believe this is due to having multiple sys_choice values that have the same label e.g. In Stock. Also, you need to veirify how the transform maps to these values and whether you allow the transform to create new values. I'd suggest not to allow transforms to create new values that indicate CI lifecycle info.