odd data import issue

[Jack62]

Evening all

I am running an excel data import into a transform table which then updates the core company table. I am getting half the records in the import set showing an error of "More than one target records exists for target table core_company with query vendor"

When I check the core_company table there is either 1 record for the company or 0. I am currently coalescing on company name and it should insert when there is not match.

Any thoughts on what is causing this?

Jack

[James Chun]

Hi @Jack62,

Do you mind sharing the configuration of the transform map? (e.g. field mapping, transform script if any)

Looking at this previous article and your error, it's likely that there are multiple Company records with the same value of 'Vendor'.

https://www.servicenow.com/community/developer-forum/transform-map-update-ci-s-that-match-on-serial-...

But since you are using the name as the coalesce, I am not sure why you are getting the error 😞

Having a look at the config may help.

Cheers

[Jack62]

Hey James, thanks for the response. Please see screenshot below - no scripts needed right now just basic mapping to update and create record based on Vendor name. Oddly it is trying to map, for instance, ZoomInfo Technologies LLC to the wrong company record on our side?? I have deleted the transform map and recreated but still get the same. 

[James Chun · Accepted solution]

No worries, looking at the screenshot, it seems like you are coalescing by the 'vendor' field, not the 'name' field.

[Jack62]

It is clearly too late here and my eyes are not seeing what it should. Thanks James, you are a true gent.

Jack