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".
Announcement
Collapse
No announcement yet.
Data Compare - keep column headings in Data Compare Report
Collapse
X
-
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.
Erik Scooter Software
Comment