Create two records from single row using transform map

[MercBuilding]

Hi

  We have an excel file which creates records in alm_hardware table using transform map. Now we want to create two records in the target table from single row. Please let me know how it can be done.

Appreciate your help!

[Amit Gujarathi]

HI @MercBuilding ,
I trust you are doing great.

To create two records in the target table from a single row in the Excel file using a transform map in ServiceNow, you can follow these steps:

1. Create a new transform map in ServiceNow. Navigate to "System Import Sets" and select "Transform Maps."

2. Define the source table as "alm_hardware" and map the appropriate fields from the Excel file to the corresponding fields in the target table.

3. In the transform map, click on the "Advanced" tab and locate the "Create Extensions" section.

4. Enable the "Create two records" option. This allows you to create two records in the target table from a single row in the source file.

5. Specify the conditions for splitting the single row into two records. For example, you can use a specific field value or a combination of fields to determine when to split the record.

6. Save the transform map.

7. Now, when you perform the import using the transform map, the records in the Excel file will be split into two separate records in the target table based on the conditions defined in the transform map.

Here's an example code snippet to illustrate the process:

var importSetGr = new GlideImportSet();
importSetGr.initialize(); // Initialize the import set

var importSetRowGr = new GlideImportSetRow(importSetGr);
importSetRowGr.setValue('source_table', 'alm_hardware');
// Set other field values as per your requirement

var importSetLoader = new GlideImportSetLoader();
importSetLoader.loadAllSets(); // Load the import set

var transformMapGr = new GlideImportSetMap();
transformMapGr.get('your_transform_map_sys_id').runTransform(importSetRowGr); // Replace 'your_transform_map_sys_id' with the actual sys_id of your transform map

// The records will be created in the target table based on the defined conditions in the transform map

[MercBuilding]

Hi @Amit Gujarathi ,

   Thank you so much for your reply but i dont find the 'Advanced' tab in transform maps. Do you mean 'Tranform Scripts' section, please let me know.