Hi @sri83 ,
To process the "applications" array related data into the target table fields, you can use a transform map in ServiceNow.
First, create a new transform map and select the import set table as the source table and the target table as the target table.
Next, map the fields in the target table to the corresponding fields in the import set table.
To map the fields in the "applications" array, you will need to create new fields in the target table for each of the "name" fields in the array. For example, if the "applications" array contains "name 1" through "name 5", you would create fields in the target table with the same names.
Then, for each of these fields, you can use a script to extract the corresponding value from the "applications" array. For example, to extract "value 1" from the first element of the "applications" array, you could use the following script:
var apps = source.u_applications;
if (apps && apps.length > 0) {
target.u_name_1 = apps[0]['name 1'];
}
You would need to repeat this for each field in the "applications" array that you want to extract.
Finally, run the transform map to import the data from the import set table into the target table, and the data from the "applications" array should be correctly mapped to the new fields in the target table.
If my response was helpful in resolving the issue, please consider accepting it as a solution by clicking on the ✅Accept solution button and giving it a thumbs up 👍. This will benefit others who may have a similar question in the future.
Thank you!
Ratnakar
