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🙂