How to ignore certain source data coming in IntegrationHub ETL?

Subhashree Sub2
Tera Contributor

‎03-19-2024 07:17 AM

Hi Team,

 

We have a requirement to ignore data transform to 'cmdb_ci_printer' table for the condition "Lifecycle status is Empty".

We have ETL configured for this transform however, I am unable to restrict the empty lifecycle status data.

The target table 'cmdb_ci_printer' has Default value set for column "Lifecycle Status" as '1' (Installed). My requirement is not to transform any BLANK lifecycle status to the target table.

 

Please share your suggestion on this.

 

Thanks and Regards,

Subhashree

0 Helpfuls
  • 1,137 Views
6 REPLIES 6

James Chun
Kilo Patron
In response to Subhashree Sub2

‎03-24-2024 02:35 PM

Hi @Subhashree Sub2,

 

Are you using IntegrationHub ETL? And do you mind sharing the onBefore script as well?

 

Cheers

0 Helpfuls

Brian Bush
Giga Guru

‎07-09-2025 12:15 PM

You could use an onBefore script in the integration data source to mark the record status SKIPPED on your lifecycle status condition. I don't think this works when you need the condition to be based on a transformed value, but if it is the raw importset payload, it should work.
Add before and after scripts to an integration data source

0 Helpfuls