Episode 28 - Robust Transform Engine & Extract Transform Load in ServiceNow

Goran WitchDoc
ServiceNow Employee
‎02-10-2020 07:22 AM
Showing a quick tour on how to use the new functionality in ServiceNow's Orlando Release. The Robust Transform Engine (RTE) & Extract Transform Load (ETL) is a new powerful way to handle the import of data.
Comments
Mohammad Sannav
Tera Expert
‎02-10-2020 07:22 AM
‎02-10-2020 07:22 AM

Thanks for the overview. Could you please let me know is there any option to check the target field value before updating it with temp value.

 

For example: I want to check target field value is empty or not before updating this with temp value.

 

Deepak75
Tera Expert
‎02-10-2020 07:22 AM
‎02-10-2020 07:22 AM

Hi,

 

Do we have any documentation available how can we do it for 2 target from one source using some query condition ?

Can someone help on documentation ?

 

Thanks

 

VaranAwesomenow
Mega Sage
‎02-10-2020 07:22 AM
‎02-10-2020 07:22 AM

Implementing ignore creation of record via robust transform is a little tricky but below is how it can be done.

You can implement this in 3 ways
1. Implement on before script
    gliderecordusing key field from source / target -> if found
        //status = 'SKIPPED';
        or
        //ignore = true;
2. Implement on after script
    On after can access target Object, so you can run a set query to check if its a valid record or not and do a delete.
3. Write a post import script on scheduled import that will do the delete