Comparing two files - matching column headings to old file and identify new headings?

[Lili7891]

Hi,

I have 2 files - an old file and new file, this might be a pretty simple one but I am having a blank moment here - please could you help re:

1. Adjusting the new file to match the old file set up - headers only - do not need to pull the cells through e.g.

Old file:

Column A	Column B	Column C	Column D	Column E	Column F	Column G

New File:

Column A	Column C	Column D	Column E	Column F

What I want to achieve with Combined File - Either highlights missing heading added back in (ideal solution):

Column A	Column B	Column C	Column D	Column E	Column F	Column G

or puts the missing headings at the end:

Column A

Column C

Column D

Column E

Column F

Column B

Column G

I know I could potentially use a text input file, but both the files in question have multiple columns and may potentially change again in the future so want to be able to automatically pull through any changes to match.

Hopefully makes sense, but happy to provide more detail if required - unfortunately can't share the files I am working on.

Thanks,

[DavidP]

Hi @Lili7891 

How about this: Strip the data from the old file with a sample tool, then Union the 2 files together.

[Qiu · Accepted solution]

@Lili7891 
Did not get your ideal solution, though maybe can be done by reporting tool.

[mbarone]

You can use a union tool.  It will bring all your columns in, but will stack the data so you'll have to come up with an aggregation if you want to combine the data.

[Lili7891]

Thanks so much!

[Qiu]

@Lili7891 
Thank you for the mark.