IntegrationHub ETL - ignore row

[Anton15]

Hi

Using IntegrationHub ETL, is it possible to ignore certain rows with specific values?

By ‘ignore’ I mean do not insert the row into the target table.

Thanks

[Kieran Anson · Accepted solution]

Hi Anton,

You can specify a before script on the CMDB Integration Studio Application Data Source record as defined in this doc Add before and after scripts to an integration data source (servicenow.com)

"  * 3) The 'status' can be set to 'SKIPPED' in order to skip a payload in this batch from further processing. Setting 'status' to any other value will be ignored by the RTE processo"

[Anton15]

Perfect! Thanks Kieran

[#4]

I would look into conditional classes within the ETL mapping.

This will allow you to specify a condition to insert/update a class.  You can use the existing fields if it is a simple check (IE: There may already be a field called "ignore" that you will use for the condition).  If it isn't a simple field check you can create a script operation to set a value of a new field.  You can then use the output field of this script operation in the conditional class.

[Anton15]

Thanks - will look into this.