how to create transform map for both tables (CMDB_CI & cmdb_ci_pc_hardware )

[Kishor Mudhili]

I have created the transform map to uload the data into CMDB_CI table, uanble to find target table fields --- > Internet Facing , OS Version , Operating System. i recognized those are existed in cmdb_ci_pc_hardware . so how we can import the data. please suggest. 

[jaheerhattiwale]

@Kishor Mudhili cmdb_ci_pc_hardware is the child of cmdb_ci itself. If you create record in cmdb_ci_pc_hardware then its like you created a new cmdb_ci record itself.

So please change the target table to cmdb_ci_pc_hardware. That should solve your problem.

Please mark as correct answer if this solves your issue.

[Johns_MP]

Hi @Kishor Mudhili ,

I would suggest you to create a transform map with the table cmdb_ci_pc_hardware table. Because cmdb_ci is a parent table of all the classes. if there are multiple class data then you can create multiple transform map with the onBefore or transform script (for each particular class) and add it to a single data source and use it.

Let know if you need more help on this.

[Kishor Mudhili]

if you have can u please provide onBefore or transform script ? 

[Johns_MP]

Hi @Kishor Mudhili ,

Suppose think that you have an excel where there is both Linux and Network records.

In this case you need to create 2 transform map (one for Linux table and another for Network Table).

in the Linux transform Map you need to define the transform script as below:

if (!(source.u_class == 'Linux')){    //assuming Class is the header and Linux is the value

ignore = true;

}

in the Network transform Map you need to define the transform script as below:

if (!(source.u_class == 'Network')){    //assuming Class is the header and Network is the value

ignore = true;

}

Mark helpful if it resolves in solving your query