Bulk data update in knowledge article

[AmitK1382912422]

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]

Hi @AmitK1382912422 

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

[SumanthDosapati]

@AmitK1382912422 

Which field did you use coalesce on? 

What logic did you use in transform map?

Please share more details.

Regards,
Sumanth

[AmitK1382912422]

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