What exactly is the use of 'Run script' in a transform map? I am not looking for definition, but need some use case scenarios to understand the actual use of it.
I have seen few posts like this - https://www.servicenow.com/community/developer-forum/how-to-use-run-script-in-transform-map/m-p/2439... where it says you can do data validations, but you can do that validations in the field mapping part only right?
@Suggy If "Run script" is selected then you can use script to map source table fields to target table fields. We use this whenever you want to alter/change the source field data then assign it to target fields.
Let say we have a "sys_user" as target table and "Imp_user" as source table. In User(sys_user) target table, we have field called as "user_name" which is combination of "First Name" and 'Last Name'. But in the source table(Imp_user). we have two separate fields "First Name" and "Last Name". So in this case, I need to concatenate "First Name" & "Last Name" of source table and then map it to "user_name" field of target table. This we can do by using script only by checking "Run script" checkbox.
If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!
