Populating the value from a field on one table to a field on another table

[Community Alums]

I need to copy the value from one field on one table to a field on another table. What is the best way to configure this?

[Samaksh Wani]

Hello @Community Alums 

Pls find the link below for resolving your query :-

https://www.servicenow.com/community/service-management-forum/populate-field-on-one-table-from-field-on-another-table/m-p/381666

Plz mark my solution as Accept, If you find it helpful.

Regards,

Samaksh

[AshishKM]

Hi @Community Alums 

You can write a BR [insert, update] on table1 and read the column data and update the same in table2 column. 

You can write fix script [ if bulk data update required ] and read the data from table1 column and update the same in table2 column. 

Let us know if you need more help on code part , if yes, please share the table and column name.

-Thanks,

Ashish

[Community Alums]

Hi Ashish,

Thank you for your response. I do need more help with the code.

The table the data is coming from is sn_gf_program_measure.

The two field names are:

u_target_modifier 

u_measure_reporting_type

The table I need the values to appear in is sn_gf_fiscal_year.

And the field names are the same:

u_target_modifier 

u_measure_reporting_type

[AshishKM]

Is there any common column in both the table to identify matched record.