Duplicate Sys_ID fields?

[Riley Kippes]

I have a table that for some reason, has two identical fields both labeled Sys_ID, name being Sys_ID, etc. This is introducing a lot of problems. How do I combine the two?

[Tony Chatfield1]

There should be only 1 system created field with a column name of sys_id and a type of 'Sys ID (GUID)'
Are you sure they are both system created fields and one is not a user created\custom field with a column label of sys_id?
If one of the fields is a custom field then you should not be merging this field data with that of the system unique identifier (sys_id)

Perhaps you can attach an xml of the 2 fields for clarification?

[miked_jones]

I assume this is a custom table. How was the table created?

ServiceNow automatically adds a sys_id column (along with several others like sys_created_by, sys_updated_on) and generally won't let you add a column with an identical name. 

Do both of them have a "type" of "Sys ID (GUID)"?

You also can't (normally) delete the system generated columns from a table, so your best bet might be to check and see if you are able to delete one or the other. If not, you may need to recreate the table?

[Riley Kippes]

I created it inside of Studio using the create file button. And yes, both have the type Sys ID(GUID)

I think that the problem is that I created a table, deleted it, and created a new table with the same api name. 

[Dzmitry Milanov]

Sorry for necropost, but i assume it can be an answer:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0965375