Coalesce on a reference table item

[scott_moen]

I am attempting to import a big list of relationships into cmdb_rel_ci using an Import Set. When I define my Transform Map I create a relationship between a hostname in the import table and the target "child" which is a reference table. I have experimented in the field map settings with setting the referenced value field name (and leaving it blank) and also setting the choice action to "reject" but regardless of the combination of these settings, when I run the transform I end up with a new record inserted.

I have experimented enough with coalesce on table elements so I am pretty comfortable with making it work in that context. Is it possible to coalesce on a reference table item as described or do I need to add a custom script to make this work?

[ThadHunter]

We are unable to get an import/transform to cmdb_ci_rel to coalesce properly, so we always get new records inserted.
We've made the transform as simple as possible, ie we are importing two hostnames for each CI Relationship and mapping them to parent.name and child.name and checking coalesce=true for both fields. So far there is no answer from support. This there something unique about importing CI Relationships?

[nikita_mironov]

Hi ThadHunter
Where do you get new records created whiel importing data to to cmdb_rel_ci table: in cmdb_ci or cmdb_rel_ci table?

[ThadHunter]

I'm not sure what your question is, but the source of our CI Relationship records is an Import Set. For now it's a simple Excel import.

[nikita_mironov]

Attached is the screenshot of 100% working load to cmdb_rel_ci table. New records are created if coalesce by child, parent and type (all three) fails. Also rejects if either of field references does not exist.

[ThadHunter]

Our import/map matches your example; however, it does not work for us.