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.

Source Field Map Scripts

Khozema Attar1
Tera Guru

Hello Experts,

I am using a Field map Source Script, the requirement is to set the impact field on incident table on the basis of incoming priority from the source table.

Ex. if the priority from the source table is 1 then the impact on target incident table should be set to 3-Low( value for this choice is 3).

Written the following but it isn't working.

Can anyone help on this?

find_real_file.png

find_real_file.png

Thanks

Khozema

1 ACCEPTED SOLUTION

Yes, you have to select the target field and target table in transform map



find_real_file.png


find_real_file.png


View solution in original post

9 REPLIES 9

Hi Balaji,


The priority values are coming from a table on 3rd party system and on the basis of incoming priority we have to set the value of   Impact on our incident table.


Yes, you have to select the target field and target table in transform map



find_real_file.png


find_real_file.png


Hi Balaji,



This return 3, return 2 are values of priority in incident table.....but i need to set the impact value to 3 when the priority from the source table is 1.


what these return2 and return3 are doing?


return 3; means it will set 3 - Low for impact on incident table


return 2; means it will set 2 -   Medium for impact on incident table


return 1; means it will set 1 - High for impact on incident table


Hi Balaji,



It worked!



Thanks