It does not seem possible to compare using the data compare session unless the data has a key column. This works fine for database work, but when comparing xls sheets, that may have spaces in the first column or duplicate contents, it does not work. The default of column 1 being a key column makes BC compare totaly different lines against each other.
Is there any way to have a cell-by-cell compare?
I created a new text based compare using the same xls2csv program (the BC2 way) and though output is not aligned by the commas, the data does stay in the correct order.
Is there any way to have a cell-by-cell compare?
I created a new text based compare using the same xls2csv program (the BC2 way) and though output is not aligned by the commas, the data does stay in the correct order.
Comment