The CreatorCon Call for Content is officially open! Get started here.

Update all the previous records and keep the current

Jake Adams
Tera Contributor

Hi,

 

I have an import API on Key Values (cmdb_key_value) table. It has only four fields CI, Key, Tag, Value. 

 

In the import I might get a record with same CI, Tag, Value as below:

 

JakeAdams_0-1698588102320.png

 

Now if I again get an new import with the same CI, Tag and Value. I want to keep only the latest record and in all the above 3 records the Key value must be updated to blank/Inactive.

 

How can I achieve this?

 

5 REPLIES 5

No the client don't want this to be done through Business rule and must be done on the Transform script.

 

Any idea on why the onBefore transform script is not working?