Use parent transform map for record of child tables

[Al_Andrea]

Hi.

Hi have a parent table and six child tables, and I need to import data into ServiceNow from different Excel sheets.

Now I was thinking about creating a single transform map for the fields of the parent table and then creating another transform map, one for each subclass, to run on top of the other to add the fields of the child table to the record.

The thing is, if I run the parent transform map first I am going to insert the record in the parent table, and then I would need to reclassify the record in the correct subclass (by the way, is that possible?).

I could run the transform map first, but then maybe I could have some mandatory fields missing from the parent and I would already have created the record.

These were the first ideas I came up with to tackle this import.

Do you have any other idea for a clean and maintainable solution?

[GlideFather]

Hi @Al_Andrea,

that would be possible but your parent table would need to have all the fields from all the children..

Simplified example: 

• Child 1 has a field A, 
• Child 2 has a field B, 
• Child 3 has field a C,
• Child 4 has field a D,
• Child 5 has field a E,
• Child 6 has field a F.

• Parent must have field A, B, C, D, E, F + all mutual fields across 1-6..
  • they can be hidden unless they are mandatory,
  • or hidden and not mandatory for Parent and dictionary override for child table(s)

I would need to play around with that but perhaps you could use a staging table (import set), load data in that one and have the transform map with the classificaiton directly, so with that you can actually skip loading to the Parent unless necessary...