How to import data into different cmdb tables based on the 'Class' column in spreadsheet

[Susmitha1625]

Hello,

I want to import data into Configuration Item Tables based on the 'Class' column in the data source. But, I can't set the class name in the cmdb_ci table. The CIs are being imported to the parent table only. Please help me. Is it possible with a single transform map or Do I have to create a transform map for each class? TIA

[SanjivMeher]

You should be able to set the class using the transform map field mapping. Have you disabled the Business rule in the transform map?

[Michael Fry1]

You should be using Integration HubETL. That will not only bring the data into the right table but you can build the relationships out as well! You can't do that in a regular transform map.

[Susmitha1625]

@SanjivMeher 

I've tried it, but still it's creating the CI in the parent table. 

[SanjivMeher]

Can you post a screenshot of the field mapping?

If it doesnt work, I would try to use transform Map Before Script to set the class.