Best Way to Run Multiple Transform Maps off one Import Table

[anfield]

I will be connecting an integration to an external system where CI data will be fed into servicenow. I'm thinking of pushing this data to one import table and connecting multiple transform maps where each one would only fire and process if the device is a certain type. What would be the best way to do that? For example if the field on the import table has u_category != 'AirConditioning' then ignore = true otherwise run this transform map. Each transform map would be similar., in that it would process only if it matches a specific CI category.

Would it best best to put this in the OnStart script in each transform map? Obviously id want this to work in the most efficient way possible, Thanks

Considering the above design. Otherwise I would have around 10-15 import tables for all the device types that I need to import

[anfield]

Michael. Thats what i have setup, but my script tells it to ignore if the category isnt what each transform map wants. For example:

PDU Device on before script:

if (source.u_category != 'PDU'){

ignore = true;

gs.log('PDU Transform Skip: Category: ' + source.u_category);

}

Am I missing something?

[Pooja Mallikarj]

Hi,

I think you could do that with only one import set table and multiple transform maps  with onBefore transform map script and all the transform maps will run in order once you select in the selected transform map list.

Thanks,

Pooja M 

[anfield]

Hi. I dont want to select anything manually. This should be automated. I think it will work with the onbefore script in each transform map referring to different categories

[Andrew Barnes -]

Greetings anfield, 

 You appear to be getting decent help at your request. I am going to suggest that you don't do as you have planned, but instead do an import set table for each different class. The fields, frequency, source system, etc could all potentially change on a per class basis. 

-AJB

[anfield]

Andrew. I am keeping an open mind. For now I want to see if I can get this to run from one import table to multiple transform maps, but not with multiple rows per record. I think it will get too messy.

I can always fall back to one import table, for one transform map etc. I'm familiar with that and shouldnt be a problem, but I'd like to see if I can make this method work.

The frequency etc should all be the same. Once per day this should run on the external system, and push to servicenow.