- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2022 05:52 AM
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
Solved! Go to Solution.
- Labels:
-
Data Foundations
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2022 06:03 AM
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"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-26-2022 04:45 AM
Hi Anton,
Are you able to ignore the insert using ETL. I have same kind of requirement:
1) I have to ignore update on serial number in CMDB from SCCM if serial number is already populated. How we can achieve this using ETL?
2) How to make ETL to only update existing CI's from sccm and do not make any insert?
Thanks,
Anjali
