Bulk data update in knowledge article

AmitK1382912422 · 3 weeks ago

Hi everyone,

There are multiple versions of KB articles with same number. I have a requirement to update 2 field values in latest version of KB article from an excel to servicenow. I have done it through transform map using coalesce field. But in some article it’s got update in latest version correctly & in some article it’s updated in old version instead of updating in latest version. Could anyone please help me to resolve the issue.

Thanks & Regards

Amit Kumar

Voona Rohila · 3 weeks ago

Hi @AmitK1382912422

Please share the transform map logic you have configured to find the matching record.

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Rohila V
4x ServiceNow MVP

SumanthDosapati · 3 weeks ago

@AmitK1382912422

Which field did you use coalesce on?

What logic did you use in transform map?

Please share more details.

Regards,
Sumanth

AmitK1382912422 · 3 weeks ago

Hi Team,

I have tried with coalesce filed map Then i have tried with transform script, but in both i am unable to do it. I am attaching the screen sorts.

On before script