Robust Transform Engine - script operation

[Bhavya7]

Hello, I am trying to load data using Integration hub ETL. Lets say I am trying to load data into HUA(clli, alternate name, network site) and network site (clli as coelase, location,name)Tables.

Now while loading data into network site table if that clli have an entry in HUA table then corresponding alternative name needed to be populated in the place of name feild of network site table else we can load incoming clli as name.

For this i have used script operation. 

Problem here is , records with only name feild is getting created for those records where alternative name is present in hua table .I dont want these records to be created. 

Help me with this.

Thanks in advance. 

[M Iftikhar]

Hi @Bhavya7 ,

Please refer to this community thread
Solved: Re: IntegrationHub - How to prevent a record from … - ServiceNow Community

This is a similar case as yours. They are also using IntegrationHub ETL and wants to prevent creating records based on a field's value.

If my response helped, please mark it as the accepted solution so others can benefit as well.