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

Shivani_singh
Tera Contributor

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.

1 ACCEPTED SOLUTION

@Shivani_singh 

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

The discussion can continue on your question as well.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

10 REPLIES 10

Runjay Patel
Giga Sage

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

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

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

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

 

Ankur Bawiskar
Tera Patron
Tera Patron

@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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader