Robust Transform to multiple targets ( Excel to CMDB )
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-08-2024 10:35 AM
Hi - I have a spreadsheet with multiples network items: Router, FIrewall, Switches etc (in attach)
I intend to create a process to:
- Copy the rows contaning 'Router' to 'Router Class'
- Copy the rows contaning 'Firewall' to 'Firewall Class'
- Copy the rows contaning 'Switchr' to 'Switch Class'
I created a Robust Transform (as attach)
It is working without error (in attach) , But it is not send the rows to correct target tables (as before/after screenshots)
As far as I understood, I need to add a Is Conditional Script into each Robust Entity Mapping (Right), ?
I tried to add this script , but it´s no causing any effect.
(function runTransformScript(input) {
/f (input.staging.type == 'Firewall') {
return true
} else {
return false
}
})(input);
Staging = It´s the Stanging Entity ( Source of data)
Type = It´s a field of Stanging Entity ( Source of data)
Firewall = It´s a string in some line of Stanging table
Target table = cmdb_ci_firewall_hardware
Can you please help what is missing or wrong?
Thank you
0 REPLIES 0