Transform Script

harshi_ramesh · ‎07-16-2024

Hi All

Have written a transform script, before inserting into target table will check if Class is 'PC' or 'Windows' and if so will restrict the data from getting updated.

But adding to this, we want a condition which will check if status is 'Disposed' or 'Disabled'. If a record with these are found, instead of updating existing record, it should be able to create one. How to do this?

We have mapped staging table and target table, with coalesce on name and serial number fields. All this working well, but how to get this condition to work with this.

Please help with a solution.

Thanks

Pratiksha · ‎07-16-2024

Their are two ways you can do it. First while inserting the data you can put he condition to check status if it pass create a new one.

Or call IRE in transoform map.

Create a reconsilation rule to make sure the state is not disabled or disposed.

In that way it will check the rule and if it found any records in the state then it will create a new record.

https://www.servicenow.com/community/cmdb-articles/cmdbtransformutil-usage-in-transform-maps/ta-p/26...

Rather then transform maps, I would highly recommend to use IH ETL for this.

Hope it helps.

View solution in original post

alexgilbert · ‎12-24-2024

One of the roles of a student means a constant flow of assignments and hardly imaginable time limits. When I require help, I think in terms of, writemyessayuk.co.uk. All the services provide cheap services, through which one can easily complete the work within the set standards, and at the same time, meet all the expected academic standards without spending a fortune.