hi @Hari S1
hi @Hari S1
This is not directly supported by a single import set, because each import set maps to one target table at a time. But you can achieve this by a multi-step process.
Upload your Excel as usual via Load Data (System Import Sets > Load Data).
Choose Create new table or use a staging table.
This import set table will contain all 10 columns in one record per row.
Create two transform maps on that import set table:
One transform map for the Hardware table (mapping columns 1-5). In the Field Maps related list, use Auto Map Matching Fields to map the first five columns.
One transform map for the Software table (mapping columns 6-10).
Use Transform Scripts (onBefore or onAfter Transform) to separate data, Because each transform map is triggered per row, but you want to create two records from one row (one hardware, one software), you need some scripting:
Create a transform map to Hardware.
Use an onAfter transform script to create Software record as bellow.
(function transformEntry(source, target, map, log, isUpdate) {
var softwareGR = new GlideRecord('software_table_name');
softwareGR.initialize();
softwareGR.field1 = source.u_col6;
softwareGR.field2 = source.u_col7;
softwareGR.field3 = source.u_col8;
softwareGR.field4 = source.u_col9;
softwareGR.field5 = source.u_col10;
softwareGR.insert();
})(source, target, map, log, isUpdate);
I hope my answer helps you to resolve your issue, if yes please mark my answer helpful and correct.
thank you
Rajesh
