I've run into what I believe is a bug in BC3 data compare. I am comparing 2 files that don't quite line up so I need to do some movement of the fields, and I also need to pick a different key field. In the process of doing this BC3 assigns a 2nd key field, which throws off the compare.
I'm using V3 build 462.
I have a simple way to reproduce the problem using the attached files:
Run BC3 and start a new data compare
Drag first.csv into the left pane, second.csv into the right pane
Open the Rules dialog
Delete the ID row
Set Name to key
At this point you see one key in the left hand comparison column
Select Address thru Fax in the "left file" column and click the down arrow to line up city, zip, etc.
Click Ok to close Rules dialog
Open up Rules dialog again - You'll see that both Name and Number are listed as key columns.
I'm using V3 build 462.
I have a simple way to reproduce the problem using the attached files:
Run BC3 and start a new data compare
Drag first.csv into the left pane, second.csv into the right pane
Open the Rules dialog
Delete the ID row
Set Name to key
At this point you see one key in the left hand comparison column
Select Address thru Fax in the "left file" column and click the down arrow to line up city, zip, etc.
Click Ok to close Rules dialog
Open up Rules dialog again - You'll see that both Name and Number are listed as key columns.
Comment