Source field script not working

[Raunak kapoor2]

I am trying to use a source script  on my Table field map 

where i want to map the sys_id of the record in core_company table to the company field on the current table "xyz"

can someone help me with the script

[Raunak kapoor2]

[Ankur Bawiskar]

@Raunak kapoor2 

why the field names are u_condition?

Is that a custom table with those fields?

[Raunak kapoor2]

actually the target table is different from the company table hence we have to dot-walk any fields from company table so i am using this 

and we want to bring  the sys_id of the company on that record to a new sys_id field

[Ankur Bawiskar]

@Raunak kapoor2 

not that.

I am referring to u_source_script field . Why all those fields are starting with u_?

Are you having a custom table similar to field map table?

In the script you are updating all the records of company table?

But you want to map the value with target field

It seems you are confused in your requirements.

[Raunak kapoor2]

u_source_field is there because it is a custom application called perspectium in servicenow which we use for data sharing. this field is there because of that app