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

[e_17]

@anfield seems your scenario is a good fit for robust transform engine. 

https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/import-sets/task/...

[anfield]

Thanks. I will look into this. But I am still curious to see if I can get this working with one import table and mulitple maps. From what I am seeing , ignore = true just skips processing the record, but it doesnt skip the map. So where I have 2 transform maps. I will still attempt to run the record through the second map, even though it sets to the status to Ignored.