Robust Transform to multiple targets ( Excel to CMDB )

Angelo Cortesi
Tera Contributor
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