Since you need to transform data from one staging table to multiple tables incident, problem and change. I suggest creating multiple transform maps on your Data source. Inside your transform script, you can filter the record on the basis of your filter criteria and transform the records on the respective tables.
Since you need to transform data from one staging table to multiple tables incident, problem and change. I suggest creating multiple transform maps on your Data source. Inside your transform script, you can filter the record on the basis of your filter criteria and transform the records on the respective tables.
@angel kumari I am assuming you have created a data source to import your data from an external source (API/Excel sheet/CSV) to your staging table.
I am also assuming that the table structure you have shared is of your staging table. Here the Type field can be used to segregate data for Incident, Change and problem tables.
In your data source, you will be having three different transform map, where source would be your staging table and target would be either Incident, problem or change.
Let's assume you are writing your first transform map for incident table.
Here is the configuration for the transform map onBefore script.
In the above script, we are simply checking if the type on the source field is incident, if the condition evaluates to true then we set the ignore action to false otherwise true. This makes the script to run only for those records where type is incident.
Similar transform maps can be created for change and problem records and similar onBefore script for change and problem types can also be put.
For more information on Transform map, I recommend you reading the official documentation here.
Hope this helps.
hi
i use the same script in my robust transform.
