Compare dumps for missing attributes.

[Arpan_D]

How do I compare dumps from 2 different ServiceNow instances for attributes missing in CIs. One dump contains all the required attributes/information for all the CIs. While in the other one, some attributes/information are missing for each of the CIs. Is there any way to link both the excel dumps and generate the results for missing attributes/information, for each CIs.

[SteveMacWWT]

What I do is below. It is manual, but it doesn't rcode and I don't need to do it often. 

• Get the column names (not labels) from both instances into a single spreadsheet. 
• Use Conditional Formatting > Highlight Cells Rules > Duplicate Values
  
• Use Sort & Filter > Filter to get filterable columns.
  
• In the column drop down for one of the tables, use the Filter by Color > No fill
  
• You now have a filtered list of mismatched columns