How to display the data on Close notes while importing the data from excel.

[Shivani_singh]

I am uploading the data via transform map, how can i add the value on the close notes according to the excel ,as close filed is not available in the mapping assist.
 Any help or suggestion will be helpful.

[Runjay Patel]

Hi @Shivani_singh ,

You can write transform map script like below.

// Check if the field is present in the source data
if (source.u_close_notes) {
    // Set the Close Notes field on the target table
    target.close_notes = source.u_close_notes;
}

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

[Shivani_singh]

Is there any way that i can upload the comments in work notes from excel.

[Runjay Patel]

The community now supports multiple accepted solutions, so you can accept more than one answer.

[Ankur Bawiskar]

@Shivani_singh 

are you saying close notes?

if it's not present in mapping assist, did you try creating a field map using new button?

you can also use onBefore transform script for this

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

	// Add your code here
	target.fieldName = source.fieldName; // use correct source and target field names

})(source, map, log, target);

If my response helped please mark it correct and close the thread so that it benefits future readers.