Here is a trick I use to create a file of orphan records from BC3 (exist in one file but not the other). Do a Data compare in BC3 and show just the desired orphan records (left or right side). Then from the Session menu, create a Data Compare report, side by side, HTML format, Save as file. Open the html file in Excel and delete out the empty columns (left or right side). Delete out the extra headings and leave just the column names. Save the file as .csv or desired file format.
Announcement
Collapse
No announcement yet.
Save Orphans to Spreadsheet
Collapse
X
-
This might result in fewer conversion hops
If it's data for which you want only exact matches be sure to first do this:
Session, Session Settings, Alignment tab, Check "Never align differences"
Then:
Check Show Differences, Uncheck Show Context
Click in the Left Panel
CTRL-A (Select All)
CTRL-C (Copy)
Paste into your favorite editor or spreadsheet
Click in the Right Panel
CTRL-A (Select All)
CTRL-C (Copy)
Paste into your favorite editor or spreadsheet
If you want the Left and Right Orphan list comingled, your favorite editor or spreadsheet program should be able to sort them and even eliminate duplicates, if any exist, with the click of a few buttons. I'm a TextPad junkie, but I'm sure there are equally additive and useful freebies.
Comment
Comment