Hello Ritsu,
Not sure about your requirement but I believe you can create 2 transform map having the same source table for example imp_computer import set table.
if your file is something like below:
in this there are 2 computer record and each computer has 8 disk record. So 2 computer record should be created and 8 disk record (4 disk for each computer with computer reference on it).
You can create a transform map for Computer table and set colease on Serial Number field.
You can create a transform map for Disk table and set the colease on fields like Name and Computer field (you can change this as per your need). You have to run the computer transform map 1st and then Disk transform map. On disk transform map you can use [script] type source field to get the sys_id of computer record as shown below:
answer = (function transformEntry(source) {
var computerRecord = new GlideRecord("cmdb_ci_computer");
if (computerRecord.get("serial_number", source.u_serial_number)) {
return computerRecord.getUniqueValue();
}
})(source);Field mapping for Disk table transform map:
You will see 2 computer record inserted (other 6 got ignored) and 8 Disk record as shown below:
Please mark this as helpful/correct, if it answer your question.
Thanks
