Using a single transform map, can I create records in different target tables?

[Suggy]

Is conditional Target Class based on a source column possible in a Transform map?

In an excel sheet like this

Short Description	Description	Category
Create INC	XYZ	Software
Create PRB	ABC	Hardware
Create CHG	QQQ	Network
Create INC	KKK	Network
Create INC	MMM	Network

Based on the short description, if it contains the keyword 'INC', the record should get created in incident table. If it contains the keywork 'PRB' the record should get created in Problem table, likewise 'CHG' in Change request table.

All this should happen in a single Transform map. Is it possible?

[KevinBellardine]

The way to do this with Transforms is to create two transform maps on the same transform table, and build some logic into the before script to abort the transform on specific conditions.

[Suggy]

Hi anyone?

[Mark Roethof]

Hi there,

You can do this using Robust Import Set Transformers.

Read about it in this docs page:

https://docs.servicenow.com/bundle/washingtondc-integrate-applications/page/administer/import-sets/c...

"You can transform the data as desired and then load that data to one or more target tables."

[Suggy]

Hi Mark, yes I am aware of RTE, but my requirement is to be done using Import set only. Posted this question to know if its really possible or not.