Update all the previous records and keep the current
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-29-2023 07:05 AM
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:
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-02-2023 03:10 AM
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?