Forum Discussion
Comparing two tables to identify discrepancy
That's a tricky question, given that each row is treated as unique. In other words, as far as the example posted, the rows identified are to all intense and purposes rows which are present in one table but not the other.
The question I gess is: is there a row ID in the original dataset which is kept in the new dataset for the supposedly equivalent row? Or can you include one?
For example, for these two rows:If there is a row ID in Table1 which is kept when Table2 is created, then we can compare them. Otherwise there is no way of knowing if it is a completely new row which has nothing to do with the original. Does that make sense?
That's a tricky question, given that each row is treated as unique. In other words, as far as the example posted, the rows identified are to all intense and purposes rows which are present in one table but not the other.
The question I gess is: is there a row ID in the original dataset which is kept in the new dataset for the supposedly equivalent row? Or can you include one?
For example, for these two rows:
If there is a row ID in Table1 which is kept when Table2 is created, then we can compare them. Otherwise there is no way of knowing if it is a completely new row which has nothing to do with the original. Does that make sense?