PDA

View Full Version : Data Compare - keep column headings in Data Compare Report


M_L
30-Jul-2008, 07:56 AM
It would be nice if there would be an option to keep the first line (= column headings) in Data Compare Reports (e.g. for Excel sheets), when the report options are set to "Differences".

Erik
30-Jul-2008, 09:32 AM
Actually, column names are shown in Data Compare reports. I suspect the problem is that your first lines aren't being treated as column names. To force them to be:

Select Tools -> File Formats....
Click "New..", switch to "Data Format" and click "OK".
Edit Data Format name appropriately.
On the "General" page, enter a "Mask" that will match your files.
On the "Type" page, change "First line contains" to "Column names".
Click "Save".
Click "Close".
Open your files in the Data Compare and make sure they're using your new format.

M_L
31-Jul-2008, 12:15 AM
Great, that's exactly what I was looking for. Thanks a lot!