Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

updating dot walked field through transform map

manasa0590
Tera Contributor

Hi

I am loading data to a table(name: OLA score) using Transform map.

OLA score table has a dot walked field in its list view called "Function name" which is a reference field.

When I try to map using mapping assist, the "function name" field doesn't show in the target fields list.

How to load this dot walked field using transform map.

 

Kindly help,

 

1 ACCEPTED SOLUTION

Meloper
Kilo Sage

Hi

you want to update a dot walking field in the Field Mapping of a Transform Map?

For me, that is not possible OOTB.

Use a Source Script, create a Gliderecord and Update the Field -> Targtefield NONE

 

 var gr = new GlideRecord('yourtable');
gr.addQuery('field',source.field);
gr.query();
if(gr.next()){
gr .field = source.field
gr. update();
}

View solution in original post

2 REPLIES 2

Meloper
Kilo Sage

Hi

you want to update a dot walking field in the Field Mapping of a Transform Map?

For me, that is not possible OOTB.

Use a Source Script, create a Gliderecord and Update the Field -> Targtefield NONE

 

 var gr = new GlideRecord('yourtable');
gr.addQuery('field',source.field);
gr.query();
if(gr.next()){
gr .field = source.field
gr. update();
}

manasa0590
Tera Contributor

Thank you Meloper🙂